Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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