Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

nithin_miryala
Contributor

Dimension should not be filtered based on selection

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

Tags (2)
1 Solution

Accepted Solutions

Re: Dimension should not be filtered based on selection

This?

Capture.PNG

12 Replies

Re: Dimension should not be filtered based on selection

What if you try this

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

nithin_miryala
Contributor

Re: Dimension should not be filtered based on selection

Tried it. it still filters the CPT

Re: Dimension should not be filtered based on selection

This is used a dimension, right?

nithin_miryala
Contributor

Re: Dimension should not be filtered based on selection

Yes

Re: Dimension should not be filtered based on selection

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

krishna_2644
Valued Contributor III

Re: Dimension should not be filtered based on selection

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

nithin_miryala
Contributor

Re: Dimension should not be filtered based on selection

Please find the attached sample.

Please look at it

Re: Dimension should not be filtered based on selection

I think you forgot to ignore selection in the expression

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

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

nithin_miryala
Contributor

Re: Dimension should not be filtered based on selection

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?

Community Browser