Can this be done?

[rittermd]

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?

[Gysbert_Wassenaar · Accepted solution]

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.

[rittermd]

The excel report is going away.  So I will have to do this entirely inside Qlik Sense.