Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nithin_miryala
Creator
Creator

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

1 Solution

Accepted Solutions
sunny_talwar

12 Replies
sunny_talwar

What if you try this

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

nithin_miryala
Creator
Creator
Author

Tried it. it still filters the CPT

sunny_talwar

This is used a dimension, right?

nithin_miryala
Creator
Creator
Author

Yes

sunny_talwar

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
Specialist III
Specialist III

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

nithin_miryala
Creator
Creator
Author

Please find the attached sample.

Please look at it

sunny_talwar

I think you forgot to ignore selection in the expression

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

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

nithin_miryala
Creator
Creator
Author

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?