topic Re: Help with crosstable in QlikView

Help with crosstable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

was able to do the cross table. But my column header date format is not coming proper. Attached is the excel i need Month data which is header, Attached is the excel sheet. can anyone help

Re: Help with crosstable

sunny_talwar — Thu, 08 Sep 2016 14:54:09 GMT

Try this:

Table:

CrossTable (Date, Value)

LOAD [Employee Name],

[41640],

[41671],

[41699],

[41730],

[41760]

FROM

tickets.xlsx

(ooxml, embedded labels, table is Sheet1);

FinalTable:

NoConcatenate

LOAD [Employee Name],

Date(Num#(Date)) as Date,

Value

Resident Table;

DROP Table Table;

Re: Help with crosstable

Anonymous — Thu, 08 Sep 2016 16:47:09 GMT

Let me try that rey Sunny. I got the solution but i want to check yours too.