Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


Qlik Sense Pivot

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.


1 Reply
Esteemed Contributor

Re: Qlik Sense Pivot

Sure you can,

instead of having as dimensions:

1) Year

2) Quarter

3) Month

It will become:

1) Year

2) Year&'-'&Quarter

3) Year&'-'&Quarter&'-'&Month


Community Browser