topic Re: Pivot Table Expression Filtering Clears Previously Selected Dimension Filters in QlikView

Pivot Table Expression Filtering Clears Previously Selected Dimension Filters

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Helo,

I have a pivot table with 4 dimensions (f1, f2, f3, f4) and 1 expression (sum of f5).

Pls check attached sample. I did these steps.

0. Cleared all filters.

1. Clicked on value a1 - this set a filter f1=a1

2. Then clicked on value 2 in the expression.

I was thinking it will keep f1=a1 filter and add f2=b1, f3=c1, f4=d1 but it removed f1=a1 filter and added just f2=b1, f3=c1, f4=d1.

Why would it remove f1=a1 if that filter is still applicable? Is this the default behavior? Is there anything I can do to keep the f1=a1 filter?

Thanks,

Re: Pivot Table Expression Filtering Clears Previously Selected Dimension Filters

sunny_talwar — Fri, 15 Dec 2017 16:37:04 GMT

It did not remove f1 for me

This is what I got after following the steps you mentioned above

Re: Pivot Table Expression Filtering Clears Previously Selected Dimension Filters

Anonymous — Fri, 15 Dec 2017 16:42:53 GMT

What qlikview version are you in?

Either you have a later version of 11.20.13 or you probably clicked 2 as the first step.

If I directly click 2 without filtering f1 first then it works fine. It is not only f1. If i select f1 and f2 and then click 2, it removes f1 and f2 and keeps only f3 and f4.

Re: Pivot Table Expression Filtering Clears Previously Selected Dimension Filters

sunny_talwar — Fri, 15 Dec 2017 16:46:44 GMT

I am on version 12 and I first clicked on f1 = 'a1' and then on 2 directly in the expression column

Re: Pivot Table Expression Filtering Clears Previously Selected Dimension Filters

Anonymous — Fri, 15 Dec 2017 16:48:12 GMT

Thanks. Looks like they fixed it in 12.