Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
CrossTable() read the month as text format. You will need to fix this in a Resident Load. Read here: The Crosstable Load
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
May be as attached .jpg file. Make sure you select 'Embedded Labels" under Labels field.
Select "Embedded Labels" in the first table load screen.
-Rob