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

12 Replies
sunny_talwar

nithin_miryala
Creator
Creator
Author

Wonderful. !!

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

A big Thanks to you.

nithin_miryala
Creator
Creator
Author

stalwar1‌ Can you take alook at this Aggr not working