Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Strooprover
Contributor
Contributor

Count between values aggregated for days

Hi,

 

I have a dataset where I have the lines when a article has been sold.
I would like to make a set expressions in which I count the amount of days where an article has more than 2 lines and less than 5 lines. In this case this should lead to the result of 2.

Can anyone help me with a set expression which would make this calculation?

DateArticleAmount
21-3-20211231
21-3-20211231
21-3-20211235
22-3-20211232
22-3-20211231
22-3-20211232
23-3-20211231

 

Much thanks in advance!

1 Reply
QFabian
MVP
MVP

Hi @Strooprover , please check if this is what you want :

 

OP1 :

=count(if(Amount >=2 and Amount <5,Date))

OP2 :

=count({<Amount = {">=2<5"} >} Date)

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.