Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

Re: Count values in an interval function

Try this

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

2 Replies

Re: Count values in an interval function

Try this

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

Not applicable

Re: Count values in an interval function

Works perfectly! Thanks Sunny!