Qlik Community

Qlik Sense App Development

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

fasuhaibani
New Contributor III

Conditional Count Between Two Values

HI all,

So I am new to Sense, and I have been playing with Sense's Desktop version. I have a question and I am wishing for your kind help.

I have records and I want to classify how many records are finished with < 5 hours, between 5 and 10 hours and > 10 hours. Now I have been searching and I came across this method:

Count({$<AccHoursDiff = {'< 5'} >} distinct ID)

But my issue how can I modify this function so that I can satisify the second condition without having to specify the values i.e.

Count({$<AccHoursDiff = {'5, 6, 7, 8, 9, 10'} >} distinct ID)



Thanks!

1 Solution

Accepted Solutions
MVP
MVP

Re: Conditional Count Between Two Values

May be this:

Count({$<AccHoursDiff = {'>5<10'}>} DISTINCT ID)

1 Reply
MVP
MVP

Re: Conditional Count Between Two Values

May be this:

Count({$<AccHoursDiff = {'>5<10'}>} DISTINCT ID)