topic Re: Ignore selections in a pivot table in QlikView

Ignore selections in a pivot table

Anonymous — Tue, 23 Apr 2013 09:31:22 GMT

Hello,

I've got a pivot table with dimension Customer and expressions Amount + Period.
There are two selection tables: Customer and Period.

When I change the Customer or the Period the Amount is changing.

I want to create a second Pivot table with dimension Customer and expression Amount.
When I change the Period in my selection table, I want the first Pivot table to change the Amount and the second pivot table not.

Is it possible to ignore one of the selection tables in a Pivot table?

Re: Ignore selections in a pivot table

advait_thakur — Tue, 23 Apr 2013 09:34:14 GMT

Hello,

Yes it is possible you may restrict the selection by adding Set Analysis in your expression.

By this way, if you have two pivot tables A and B then A will change and B will remain same.

Thanks

Advait

Re: Ignore selections in a pivot table

kaushiknsolanki — Tue, 23 Apr 2013 09:35:51 GMT

Hi,

You need to include set analysis to ignore the selection.

Try below expression in your second pivot.

Sum({<Period = >}Amount)

Regards,

Kaushik Solanki