Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Crosstable in Qlikview

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

Re: Crosstable in Qlikview

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
Honored Contributor II

Re: Crosstable in Qlikview

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

MVP & Luminary
MVP & Luminary

Re: Crosstable in Qlikview

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

-Rob