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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)

QFabian