Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!