Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can i count >=20 and <=40 in bar chart expression

How can i count >=20 and <=40 in bar chart expression

count({<Sum(Input31+Input32+Input33+Input34+Input35)={'>=20','<=40'}>} Name)

1 Reply
MK_QSL
MVP
MVP

=COUNT(Aggr(DISTINCT IF(SUM(Input31 + Input32 + Input33) >= 20 and  SUM(Input31 + Input32 + Input33) <= 40,Name),Name))