Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a report that I need to recreate in Qlik Sense.
It is in excel and has 20 tabs.
Each tab has the same measures but displays a different dimension.
I want to be able to create a single chart in QS and control which dimension is displayed based on a list box choice.
Can something like this be done?
Yes, that can be done. You can create a table in the script that has the dimension names in a field and let the user select one value from that field. That value can be used as a dimension in your chart with an expression like =$(='[' & only(DimensionListField) & ']')
Actually it's probably easier to create the dimension as a field in the table you create from the excel data:
MyTable:
LOAD *, 'MyDim1' as Dimension
FROM MyExcelFile.xlsx (ooxml, embedded labels, table is SheetX);
Concatenate (MyTable)
LOAD *, 'MyDim2' as Dimension
FROM MyExcelFile.xlsx (ooxml, embedded labels, table is SheetY);
etc...
Then you can simply put the field Dimension in a listbox.
It may be even more convenient to add the Dimension field to the tables in Excel.
Yes, that can be done. You can create a table in the script that has the dimension names in a field and let the user select one value from that field. That value can be used as a dimension in your chart with an expression like =$(='[' & only(DimensionListField) & ']')
Actually it's probably easier to create the dimension as a field in the table you create from the excel data:
MyTable:
LOAD *, 'MyDim1' as Dimension
FROM MyExcelFile.xlsx (ooxml, embedded labels, table is SheetX);
Concatenate (MyTable)
LOAD *, 'MyDim2' as Dimension
FROM MyExcelFile.xlsx (ooxml, embedded labels, table is SheetY);
etc...
Then you can simply put the field Dimension in a listbox.
It may be even more convenient to add the Dimension field to the tables in Excel.
The excel report is going away. So I will have to do this entirely inside Qlik Sense.