Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
j_qlikview
Creator
Creator

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
Specialist
Specialist

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
Master
Master

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