crosstable

[#1]

Hi Experts,

i have the below scipt in my load

CROSSTABLE(TestID, TestResult,4)

what does this mean?

i know a bit about cross table but what is this 4 mean?

Please someone help

[satheshreddy]

Hi Rajendran,

whatever you are given EXP, is cross table Exp

CROSSTABLE(TestID, TestResult,4)

TestID ----> this is Attribute Field.

TestResult ----> this is Data Field.

4 ---> this is Qualifier Fields( how many fields you want to take qualify)

Regards

Sathish

[sunny_talwar]

You can also read abou this here:

Crosstable ‒ Qlik Sense‌

The Crosstable Load

[#4]

i know that cross table is used to convert the columns into rows ,  and i would like to know about. is it possible to change the rows to columns using cross table.

[sunny_talwar]

For that you need The Generic Load

[tripatirao]

Hi ,

Please  go through below link.

Cross Table in QlikView – Learn QlikView

Regards

Tripati