Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

marcoyukon
Contributor

Qlik Sense Pivot

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

1 Reply
OmarBenSalem
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

Capture.PNG

Community Browser