topic Re: Pivot Table (how to apply conditional to dimension) in QlikView

Pivot Table (how to apply conditional to dimension)

Anonymous — Tue, 16 Dec 2014 09:04:04 GMT

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.

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

Tue, 16 Dec 2014 09:31:31 GMT

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

Br,

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

Anonymous — Tue, 16 Dec 2014 09:49:42 GMT

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

Regards.

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

Tue, 16 Dec 2014 11:27:21 GMT

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?