Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
RutiTaumanRubin
Creator
Creator

Ignore dim in Expression - Qliksense

Hi Everyone.

I createD Barchart with 2 dimensions: Managers,Ranges.

The Ranges dim include the values: Max , Min

I also have measure that calculate as following:

COUNT(IF(IsNull(RANGES)=0,IDS)/
COUNT(If(RECEIVED_B=1,IDS))

I want the denominator will ignore the dim Ranges.

I try to change the calculate as following , but it didn't work:

COUNT(IF(IsNull(RANGES)=0,IDS)/
COUNT(total<Ranges> If(RECEIVED_B=1,IDS))

Any Idea?

Thank you.

0 Replies