Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to load the data?

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

9 Replies
petter
Partner - Champion III
Partner - Champion III

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?

thakkarrahul01
Creator
Creator

‌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

shiveshsingh
Master
Master

Hi

Which sheet do you want to upload in Sense? What's the logic for your output?

Thanks

Anonymous
Not applicable
Author

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  ...........................................................................................................................

Anonymous
Not applicable
Author

Thanks for your suggestion, but I'm not getting the desired output. It is Sheet 2 which needs to be uploaded in qlik sense

Anonymous
Not applicable
Author

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.

sujeetsingh
Master III
Master III

Can you give a sample app.

Anonymous
Not applicable
Author

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    

alexpanjhc
Specialist
Specialist

are you using Qlik Sense?

Have you tried

Generic SELECT* from YourTable;


see help below

https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/DataSource/generic-databases.h...