topic Re: Dimension should not be filtered based on selection in QlikView

Dimension should not be filtered based on selection

nithin_miryala — Mon, 26 Jan 2026 18:19:17 GMT

Hi Everyone,

I have a chart which has 5 Cpt's it when i do not select nothing, but when i select a provider it narows down to 3 of them,

I want the Dimension to have 5 even if select the any provider

Here is the expression: = aggr(Only({<EMVisitTypeDSC={'NPV'},Provider=>}CPT),CPT)

Let me know your thoughts

Re: Dimension should not be filtered based on selection

sunny_talwar — Thu, 05 Apr 2018 15:28:22 GMT

What if you try this

Aggr(Only({1<EMVisitTypeDSC={'NPV'}>} CPT), CPT)

Re: Dimension should not be filtered based on selection

nithin_miryala — Thu, 05 Apr 2018 15:30:11 GMT

Tried it. it still filters the CPT

Re: Dimension should not be filtered based on selection

sunny_talwar — Thu, 05 Apr 2018 15:30:38 GMT

This is used a dimension, right?

Re: Dimension should not be filtered based on selection

nithin_miryala — Thu, 05 Apr 2018 15:33:39 GMT

Yes

Re: Dimension should not be filtered based on selection

sunny_talwar — Thu, 05 Apr 2018 15:34:26 GMT

Would you be able to share a sample to show where this isn't working? I don't see anything wrong with the syntax

Re: Dimension should not be filtered based on selection

Qrishna — Thu, 05 Apr 2018 15:37:08 GMT

Aggr(Only({1<EMVisitTypeDSC={'NPV'},Provider=>} CPT), CPT)

Re: Dimension should not be filtered based on selection

nithin_miryala — Thu, 05 Apr 2018 16:21:53 GMT

Please find the attached sample.

Please look at it

Re: Dimension should not be filtered based on selection

sunny_talwar — Thu, 05 Apr 2018 16:26:16 GMT

I think you forgot to ignore selection in the expression

=sum({<EMVisitTypeDSC={'NPV'}, ProviderNBR>}EMVisitCNT)/

sum({<EMVisitTypeDSC={'NPV'}, ProviderNBR>}TOTAL EMVisitCNT)

Re: Dimension should not be filtered based on selection

nithin_miryala — Thu, 05 Apr 2018 16:31:29 GMT

I did it intentionally as i want to show zero on the that particular CPT.

and i should be able filter graph but not the number CPTs in the dimension.

is that possible?

Re: Dimension should not be filtered based on selection

sunny_talwar — Thu, 05 Apr 2018 16:40:44 GMT

This?

Re: Dimension should not be filtered based on selection

nithin_miryala — Thu, 05 Apr 2018 16:46:16 GMT

Wonderful. !!

I never used RangeSum(), Have to look into it.

A big Thanks to you.

Re: Dimension should not be filtered based on selection

nithin_miryala — Fri, 06 Apr 2018 21:31:14 GMT

stalwar1‌ Can you take alook at this Aggr not working