Excel Load in Qlik Sense

[pradnya_amol]

Hello All,

I have an Excel file with the Project related data in it. Attached is the sample Excel file and QVF file. (Apologies I cannot attach the original data file) but the structure is same only the data inside is changed.

Help me to load it in QS with correct format. I am somehow not able to get the correct data in it like Excel.

Like the wk32 should go under Aug-18 but QS is taking it as Number 43312.

ALso Wave 1 and Wave 2 are 2 categories under same Column "Milestones/Activities".

Kindly help me with the loading issue.

Thanks and Regards,
Pradnya.

[JustinDallas · Accepted solution]

You would have to work the Excel file, probably with Excel macros or something to get it into a more pliable format.  The way it is now, its obnoxious to work with.

[pradnya_amol]

Thanks Justin. I did mend the data according to the requirement.