Pivot Table selected values

Mon, 26 Jan 2026 18:19:17 GMT

Hello I have a pivot table.

Is it possible that my table only reacts on changes of one variable used?

Re: Pivot Table selected values

Anonymous — Wed, 03 Dec 2014 02:11:31 GMT

Hello, Ama.

Yes, it's possible. You can use an expression set analysis to disregard selections on specific fields. Let's say your data model has the fields Client, Product and Year but you don't want the selections in Client and Product to affect the pivot table. You would write your expression(s) like this:

Sum({$<Client=, Product=>} Sales)

With expressions like these, only Year would make the pivot table react.

Hope it helps,

- Bruno

topic Pivot Table selected values in QlikView

Pivot Table selected values

Re: Pivot Table selected values