Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pradnya_amol
Creator
Creator

Excel Load in Qlik Sense

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.

1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III

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.

View solution in original post

2 Replies
JustinDallas
Specialist III
Specialist III

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
Creator
Creator
Author

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