Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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

This?

Capture.PNG

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