QlikSense Data Cleaning challenge: Learn how to use Len,left, right, Index, subfield to clean data.

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@abhijeetjoshi-gl9hy]

Best Ever explanation on the topics related to Qliksense on entire youtube.Hats off Thanks a lot

[@thinkmetrics]

🙌🏻🙌🏻🙌🏻

[@Account2129]

10:21 why do we need to do an alternative load? Why can't we just add the code to the end? Thanks

[@rajeshv8012]

Excellent explanation, Appreciate your efforts.

[@thinkmetrics]

THanks!

[@azadehmshchn4114]

keep up the good work! super helpful

[@thinkmetrics]

Thank you! 🙌🏻

[@rams_stuff]

Thanks 👍 for excellent information

[@thinkmetrics]

Thanks

[@gordonash6031]

Great video - how would you find the first occurrence of a non-numeric after the XY32 ? Like if there was a XY33 we couldn't use the literal in the index clause?

[@304varun5]

Can you please explain how to write complex set expressions

[@thinkmetrics]

Sure.

[@304varun5]

@@thinkmetrics Thank you especially regarding addyears, addmonths, ytd, qtd and wtd set expressions

[@mangammakashaboina2476]

Superb

[@thinkmetrics]

Thank you 🙌🏻🙌🏻🙌🏻

[@Enaklam]

LOAD * From Perfect_Table Where Data='Clean';

[@thinkmetrics]

hahaha Amazing!!!!!

[@vamshikn]

This worked for me! Without using the len, index functions load *, SubField(first_lastname,'.',1) as first_name, SubField(first_lastname,'.',2) as last_name ; LOAD objectid, SubField(objectid,'2',1), SubField(objectid,'2',2) as first_lastname, SubField(objectid,'.',1) FROM [lib://DataFiles/datacleaningfile.xlsx] (ooxml, embedded labels, table is [data cleaning]);

[@thinkmetrics]

Nice 👍🏻

[@ОлександрКостенко-з1з]

can be even shorter ) LOAD objectid, SubField(objectid,'.',-1) as name, SubField(SubField(objectid,'XY32',2),'.',1) as surname