Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

maxsugak
New Contributor

Help with crosstable

Dear fellows,

need help to cross table with multiple values, tried a lot but always get it wrong.

Please check Excel attached.

 

View or Sense, does not matter.

 

Thanks!

1 Solution

Accepted Solutions
rogerpegler
Contributor

Re: Help with crosstable

In Excel, copy and paste with the transpose option, so that you now have something like the attached.

The load code would then be:

CrossTable(FieldName, Data, 2)
LOAD F1 as Week,
CTV,
[5tgb4],
[3f4efn],
v34ge,
[56j56j],
m5j6hj,
[5yj56h],
h54y3
FROM
Temp2.xlsx
(ooxml, embedded labels, table is Sheet1);

1 Reply
rogerpegler
Contributor

Re: Help with crosstable

In Excel, copy and paste with the transpose option, so that you now have something like the attached.

The load code would then be:

CrossTable(FieldName, Data, 2)
LOAD F1 as Week,
CTV,
[5tgb4],
[3f4efn],
v34ge,
[56j56j],
m5j6hj,
[5yj56h],
h54y3
FROM
Temp2.xlsx
(ooxml, embedded labels, table is Sheet1);