1 Reply Latest reply: Apr 26, 2017 4:50 PM by omar bensalem RSS

    Qlik Sense Pivot

    Marco B

      Is is possible to have repeating rows during drill down on a pivot table ?

       

      Example:

       

      From this:

      Year  Measure1
              Quarter
                        Month

       

      To This - when expanded all the way to Month:

        Measure Total
      2017   2017-01  Jan220
      2017   2017-02  Feb330

       

      I can't use a tabular table since I need to pivot the data. Or if not possible, is there a setting to allow the pivot to export in this format ?

       

      Another question. Is it possible to remove from the pivot table a dimension or measure in run time.? The only option I could find is to use remote in edit mode and then applying the changes.

       

      Thanks