Cross table help in QlikSense

[#1]

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:

Year	Country	Product A	Product B	Product C	Product D	Product E
2015	Colombia	1354	1683	1693	1769	1060
2015	Egypt	1910	1455	1532	1013	1848
2015	Georgia	1341	1308	1425	1671	1928
2015	Greece	1691	1203	1262	1127	1568
2015	Guinea-Buissau	1654	1867	1085	1386	1129

Output sample based on Year:

[phaneendra_kunc · Accepted solution]

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

[#3]

Hi Phaneendra,

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

Thanks a lot.

Regards,

MSK

[jayaseelan]

Hi Senthil,

               I hope the below screen short will helps you.

[#5]

Hi Jayaseelan,

Thank you as well.

Regards,

MSK

[phaneendra_kunc]

Glad that i was able to help.

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