Loading a crosstable of this kind into Qliksense

[j_qlikview]

Hi,

I need to develop a dashboard in Qliksense and i have to load this below cross table in to environment can any one help on this

as i was not able to load it properly i followed the example in qlik sense help but it didn't worked for me and PFA  data .

Thanks in advance ,

Jahnavi Reddy.

[andrespa]

Hi Jahnavi, it depends on your business requeriments but some approach could be something like that:

cross_table:

CrossTable (type,quantity) LOAD

    F1 as  category,

  [F6] as employee

FROM [lib://Downloads/Copy Status.xlsx]

(ooxml, embedded labels, header is 2 lines, table is Sheet1)

where F1 <> 'Grand Total';

cross_table:

CrossTable (type,quantity) LOAD

    F1 as  category,

  [F7] as  department

FROM [lib://Downloads/Copy Status.xlsx]

(ooxml, embedded labels, header is 2 lines, table is Sheet1)

where F1 <> 'Grand Total';

If you have any specific requeriment, please shared and I will try to help you.

Hope it helps,

Andrés

[beck_bakytbek]

Hi Jahnavi,

look at this, i am sure , that this example helps you to resolve your issue

path to solution: Convert columns in to rows

I hope that helps

Beck