Discussion board where members can get started with Qlik Sense.
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.
Go to Solution.
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],h54y3FROMTemp2.xlsx(ooxml, embedded labels, table is Sheet1);