Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Help with crosstable

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

2 Replies
Highlighted

Re: Help with crosstable

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;

Highlighted
Specialist III
Specialist III

Re: Help with crosstable

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