Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
rittermd
Honored Contributor

Can this be done?

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?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Can 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.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Can 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.


talk is cheap, supply exceeds demand
rittermd
Honored Contributor

Re: Can this be done?

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

Community Browser