topic Re: crosstable in QlikView

crosstable

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: crosstable

satheshreddy — Wed, 11 Jan 2017 15:51:11 GMT

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

Re: crosstable

sunny_talwar — Wed, 11 Jan 2017 16:32:03 GMT

You can also read abou this here:

Crosstable ‒ Qlik Sense‌

The Crosstable Load

Re: crosstable

Mon, 22 May 2017 11:09:47 GMT

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.

Re: crosstable

sunny_talwar — Mon, 22 May 2017 11:12:03 GMT

For that you need The Generic Load

Re: crosstable

tripatirao — Mon, 22 May 2017 11:36:41 GMT

Hi ,

Please go through below link.

Cross Table in QlikView – Learn QlikView

Regards

Tripati