topic What is CrossTable in QlikView

What is CrossTable

nikhilgarg — Fri, 22 Aug 2014 08:37:24 GMT

HEllo ,

Can any one tell me what is a cross table with suitable example ??

MK_QSL — Fri, 22 Aug 2014 08:46:10 GMT

Consider that you have below table...

Temp:

Load * Inline

[

Customer, 2011, 2012, 2013, 2014

A, 100, 120, 160, 90

B, 110, 60, 70, 80

C, 120, 40, 100, 120

D, 95, 180, 200, 300

];

Crosstable will convert this data in Customer, Year, Sales Format as below..

CrossTable(Year,Sales)

Load * Resident Temp;

Drop Table Temp;

Gysbert_Wassenaar — Fri, 22 Aug 2014 08:47:51 GMT

See this blog post: The Crosstable Load

its_anandrjs — Fri, 22 Aug 2014 10:00:35 GMT

Hi Nikhil,

Read this post that will help you.

Regards

Anand