topic Re: CROSS TABLE in QlikView

CROSS TABLE

Mon, 25 Nov 2013 16:54:49 GMT

HI,

What is the way to create cross table?

i tried to make 3 columns: ID_NUMBER, NAME, MONTH.

MK_QSL — Mon, 25 Nov 2013 16:59:44 GMT

Use below in script.

TableName:

CrossTable(Month, DATA, 2)

LOAD ID_NUMBER,

NAME,

Jan,

Feb,

Mar,

Apr,

May,

Jun,

Jul,

Aug,

Sep,

Oct,

Nov,

Dec

FROM ..... your table path...

Mon, 25 Nov 2013 19:50:01 GMT

Works good. thank you.

Can you guide me step by step how to do it using Wizards?

MK_QSL — Mon, 25 Nov 2013 19:57:53 GMT

Go to the Script Editor..

Click on Table Files

Select File from appropriate location.

Now you can see Table, Header Size, Lables... Make sure you have embedded labels selected

Click Next Next (i.e. Two Times)

You will get screen from where you have to select Cross Table

Write Now Qualifier Fields.. for you 2 (i.e. ID_NUMBER and NAME)

Attribute Filed ... for you is Month

Data Field ... for you is Data or sale or value whatever you want to given name

FINISH

RELOAD

Josh_Good — Mon, 25 Nov 2013 22:20:02 GMT

Here is a video that walk you through how to load cross tables