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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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