Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Valued Contributor III

Re: Cross table help in QlikSense

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);

5 Replies
phaneendra_kunc
Valued Contributor III

Re: Cross table help in QlikSense

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

Re: Cross table help in QlikSense

Hi Phaneendra,

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

Thanks a lot.

Regards,

MSK

jayaseelan
Contributor III

Re: Cross table help in QlikSense

Hi Senthil,

               I hope the below screen short will helps you.

Capture2.PNGCapture1.PNG

Not applicable

Re: Cross table help in QlikSense

Hi Jayaseelan,

Thank you as well.

Regards,

MSK

phaneendra_kunc
Valued Contributor III

Re: Cross table help in QlikSense

Glad that i was able to help.

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