topic Re: CrossTable() in QlikView

CrossTable()

Mon, 25 Mar 2013 12:59:42 GMT

Hi all,

i have the following table format:

I want to transform the table above in a table like this:

ID	[Days in New]	[Days in Active]	[Days in In Test]	{Days In Completed]
1	3	2	1	4

I think this is possible using CrossTable(), but i cant get it to work.

Thanks a lot!

sivarajs — Mon, 25 Mar 2013 13:16:28 GMT

try using generic load

Mon, 25 Mar 2013 13:18:59 GMT

thanks, but isnt it possible to create a table like i want in the data model ?

narender123 — Mon, 25 Mar 2013 13:31:30 GMT

Hi,

for this you can use pivot table to show data like this.

see in attachment

Regards:

Narender

rustyfishbones — Mon, 25 Mar 2013 13:47:58 GMT

If you want this in the Script you could try, not sure if it's the best solution but try it

LOAD ID,

Ststus as Status,

IF(DaysInStatus=1,DaysInStatus) AS [Days In Test],

IF(DaysInStatus=2,DaysInStatus) AS [Days In Active],

IF(DaysInStatus=3,DaysInStatus) AS [Days In New],

IF(DaysInStatus=4,DaysInStatus) AS [Days In Completed]

FROM