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

    Qlik Sense Pivot

    Marco Barroso

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




      From this:

      Year  Measure1


      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.