Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

j_qlikview
Contributor

Loading a crosstable of this kind into Qliksense

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.

2 Replies
andrespa
Valued Contributor

Re: Loading a crosstable of this kind into Qliksense

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
Valued Contributor III

Re: Loading a crosstable of this kind into Qliksense

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

Community Browser