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
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER 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
Partner
Partner

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

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

Not applicable

Hi Phaneendra,

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

Thanks a lot.

Regards,

MSK

Creator III
Creator III

Hi Senthil,

               I hope the below screen short will helps you.

Capture2.PNGCapture1.PNG

Not applicable

Hi Jayaseelan,

Thank you as well.

Regards,

MSK

Partner
Partner

Glad that i was able to help.

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