Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
az1234
Contributor
Contributor

Filtering Dimensions By Range in Bar Graph

I am trying to filer a graph to show my data in ranges. i.e. how many scounts fall within a range between 0-25% and so on. This is the formula I have now. Any help would be greatly appreciated. Thanks!

 

IF(formula])>=0<0.25,('0-25%')
IF([formula])>=0.26<0.50,'26%-50%')
IF(formula])>=0.51<0.75,'51%-75%')
IF([formula])>=0.76<1,'76%-100%')))))

1 Reply
Lisa_P
Employee
Employee

Try this:
=IF(formula>=0 and Discount <0.25,'0-25%',
IF(formula>=0.26 and Discount<0.50,'26%-50%',
IF(formula>=0.51 and Discount<0.75,'51%-75%',
IF(formula>=0.76 and Discount<1,'76%-100%'))))

or use the Class function:
class(field, 0.25)