Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Pivot Table (how to apply conditional to dimension)

I have a Period list and a Pivot Table that uses this dimension. When selecting more than one Period, I would like to see only the last selected one at the Pivot Table, but the total column should consider all selected Periods. I´ve made a conditional expression  for Period dimension but it´s not fine.

[Período DRE]=right(getfieldselections ( [Período DRE] , ',',100),7)

See the attached file.

3 Replies
Highlighted
Not applicable

Re: Pivot Table (how to apply conditional to dimension)

Could you elaborate more? Or post a picture of your table? It's not clear to me what you would like to achieve.

Br,

T

Highlighted
Contributor II
Contributor II

Re: Pivot Table (how to apply conditional to dimension)

See attached PPT file. I think it´s clear.

Regards.

Highlighted
Not applicable

Re: Pivot Table (how to apply conditional to dimension)

Paulo, I think the first thing you wanted is possible (''when selecting more than one Period, I would like to see only the last selected one at the Pivot Table''). The second one is the more interesting one. As far as I know, for that to be achieveable, you should be able to edit the subtotal expression in your pivot table, but I don't know a way to do that. Do anyone else know a method to do it?