Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have an requirement wherein I need to store the data as: I have attached the xls sheet.
Output:
Date Profit Specialist Manager Alerts Sales qlr received totalof quotes
01/08 A B 1 2 3 4 5
C 6 7 8 9 10
D E 11 12 13 14 15
F 6 7 8 9 10
G 6 7 8 9 10
02/08 ...........................................................................................................................
Any lead will highly be appreciated.
Thanks and Regards,
Drishti Goel
Just to be clear - you haven't attached an xls sheet. You have attached an xlsx workbook containing three sheets named Sheet1, Sheet2 and Sheet3.
The Excel workbook opens at Sheet2 but Sheet1 also have similar data but structured differently. Which one of the sheets do you want to be used as basis for the Qlik application?
TO load data you can find details at Qlik help - https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/DataSource/load-data-from-Excel.ht...
Attached excel looks like an report in itself. You will have to identify what you information you require to reach to output and perform the cleanup / tranformations.
Regards,
Rahul
Hi
Which sheet do you want to upload in Sense? What's the logic for your output?
Thanks
I apologize for not uploading it correctly. It is Sheet 2.
Desired Output;
Output:
Date Profit Specialist Manager Alerts Sales qlr received totalof quotes
01/08 A B 1 2 3 4 5
C 6 7 8 9 10
D E 11 12 13 14 15
F 6 7 8 9 10
G 6 7 8 9 10
02/08 ...........................................................................................................................
Thanks for your suggestion, but I'm not getting the desired output. It is Sheet 2 which needs to be uploaded in qlik sense
HI Peter,
Sorry, for not uploading the data correctly. It is the Sheet 2 which we need to refer.
Output:
Output:
Date Profit Specialist Manager Alerts Sales qlr received totalof quotes
01/08 A B 1 2 3 4 5
C 6 7 8 9 10
D E 11 12 13 14 15
F 6 7 8 9 10
G 6 7 8 9 10
02/08 ...........................................................................................................................
Basically we trying to tweak PS and Manager rows into column and merging all 18 different columns into 5 category.
Can you give a sample app.
I have attached the xls workbook. We need to refer sheet 2. that is we are tweaking Profit Specialist and Manager rows into column and then trying to join all the other 17 columns into 5 different column
output:
Date Profit Specialist Manager Alerts Sales qlr received totalof quotes
01/08 A B 1 2 3 4 5
C 6 7 8 9 10
D E 11 12 13 14 15
F 6 7 8 9 10
G 6 7 8 9 10
are you using Qlik Sense?
Have you tried
Generic SELECT* from YourTable;
see help below