topic Re: Add column to Crosstable in QlikView

Add column to Crosstable

kevbrown — Wed, 11 May 2016 09:06:29 GMT

I have a crosstable but it does contact a date column. I'd like to add a date column, can i do that?

My script looks like -

CrossTable(Area, Data)

LOAD F1 AS Measures,

[Lieder 1],

[Lieder 2],

[Line 3],

[Line 4],

[Line 5],

[Line 6],

[Line 7],

[Line 8],

[Line 9],

[LR Traywash],

[Line 11],

Preparation,

[L/R Packing],

[H/R Bacon Room],

[L/R Bacon Room],

[H/R Salad Wash],

[L/R Salad Wash],

[Bread Area],

[Bay 6 & Sanitiser],

Despatch,

Hygiene

FROM

Thanks

Re: Add column to Crosstable

MK_QSL — Wed, 11 May 2016 09:09:25 GMT

CrossTable(Area, Data,2)

LOAD F1 AS Measures,

Today() as Date,

[Lieder 1],

[Lieder 2],

[Line 3],

[Line 4],

[Line 5],

[Line 6],

[Line 7],

[Line 8],

[Line 9],

[LR Traywash],

[Line 11],

Preparation,

[L/R Packing],

[H/R Bacon Room],

[L/R Bacon Room],

[H/R Salad Wash],

[L/R Salad Wash],

[Bread Area],

[Bay 6 & Sanitiser],

Despatch,

Hygiene

FROM

Re: Add column to Crosstable

sunny_talwar — Wed, 11 May 2016 09:10:15 GMT

What date are you looking to add?

Re: Add column to Crosstable

Kushal_Chawda — Wed, 11 May 2016 09:12:02 GMT

Which date you want to add?