Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Users, make your voice heard! Participate in Wisdom of Crowds® Market Study: Start Survey
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 II
Specialist II

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 II
Specialist II

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

pradnya_amol
Creator
Creator

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