Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Crosstable in Qlikview

I want to create a  cross table in qlikview from an excel file that looks like this

Capture2.PNG

When i try in qlikview i get this, the months are not there. What am i doing wrong?

Capture1.PNG

4 Replies
sunny_talwar

CrossTable() read the month as text format. You will need to fix this in a Resident Load. Read here: The Crosstable Load

marcus_sommer

They are there: 41275, 41306 ... are the numeric values of the dates which are formatted as months within your excel. You could simply load them and format or convert them later. Your load-script should be look like:

table:

crosstable(Period, Value, 1) load * From YourExcel;

- Marcus

trdandamudi
Master II
Master II

May be as attached .jpg file.  Make sure you select 'Embedded Labels" under Labels field.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Select "Embedded Labels" in the first table load screen.

-Rob