Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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

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

-Rob