Discussion board where members can get started with Qlik Sense.
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 ,
Hi Jahnavi, it depends on your business requeriments but some approach could be something like that:
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';
[F7] as department
If you have any specific requeriment, please shared and I will try to help you.
Hope it helps,
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