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: 
Not applicable

Cross table help in QlikSense

Hello,

This is from a person new to Qlik. Now I am in the process of learning QlikSense.

I need your expert help in generating two separate bar charts using the qualifiers 'Year' and 'Country'.  Product A to E are the attribute fields with 'Sales' data.

- how do I load this data using 'data load editor' or ?

- and, what should be the script?

Kindly help.

Regards,

MSK

Source Excel File:

   

YearCountryProduct AProduct BProduct CProduct DProduct E
2015Colombia13541683169317691060
2015Egypt19101455153210131848
2015Georgia13411308142516711928
2015Greece16911203126211271568
2015Guinea-Buissau16541867108513861129

Output sample based on Year:

1 Solution

Accepted Solutions
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Here is the load statement u can use.

CrossTable(Product, Data, 2)

LOAD Year,

     Country,

     [Product A],

     [Product B],

     [Product C],

     [Product D],

     [Product E]

FROM

(ooxml, embedded labels, table is Sheet1);

View solution in original post

5 Replies
phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Here is the load statement u can use.

CrossTable(Product, Data, 2)

LOAD Year,

     Country,

     [Product A],

     [Product B],

     [Product C],

     [Product D],

     [Product E]

FROM

(ooxml, embedded labels, table is Sheet1);

Not applicable
Author

Hi Phaneendra,

Awesome!  I was able to follow your suggestion and get what I was looking for.

Thanks a lot.

Regards,

MSK

jayaseelan
Creator III
Creator III

Hi Senthil,

               I hope the below screen short will helps you.

Capture2.PNGCapture1.PNG

Not applicable
Author

Hi Jayaseelan,

Thank you as well.

Regards,

MSK

phaneendra_kunc
Partner - Specialist III
Partner - Specialist III

Glad that i was able to help.

Please mark this thread with "Correct Answer" so that other members can find this helpful.