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: 
Not applicable

Count values in an interval function

Hello Community,

I am trying to get values in a table sorted in intervals with statements.

Below is sample data, the Count(Assignments) and Count({<Volume = {'>=10'} >} Assignments) works well enough, but what i need is to have multiple intervals showing different volume values. That I can't get to work..

        

CountryCount(Assignments)Count({<Volume = {'>=10'} >} Assignments)Volume interval 1 - 10Volume interval 11-50Volume interval 51-100
SE10010
DE20020
US10010
FR20020

I was thinking that it needs to be an IF statement or some variation of the Count statement.

Example:  Count({<Volume = {'>=1' and '<=10'} >} Assignments)  - but that did not work

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Try this

Count({<Volume = {'>=1<=10'} >} Assignments)

View solution in original post

2 Replies
sunny_talwar

Try this

Count({<Volume = {'>=1<=10'} >} Assignments)

Not applicable
Author

Works perfectly! Thanks Sunny!