Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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


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


4 Replies

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

MVP & Luminary
MVP & Luminary

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:


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

- Marcus

Master II
Master II

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


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