Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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

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)

View solution in original post

Not applicable
Author

Works perfectly! Thanks Sunny!