2 Replies Latest reply: Apr 7, 2016 9:13 AM by Mark Ritter RSS

    Can this be done?

    Mark Ritter

      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?

        • Re: Can this be done?
          Gysbert Wassenaar

          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.