Count between values aggregated for days

Strooprover — Tue, 23 Mar 2021 13:04:21 GMT

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?

Date	Article	Amount
21-3-2021	123	1
21-3-2021	123	1
21-3-2021	123	5
22-3-2021	123	2
22-3-2021	123	1
22-3-2021	123	2
23-3-2021	123	1

Much thanks in advance!

Re: Count between values aggregated for days

QFabian — Tue, 23 Mar 2021 14:42:22 GMT

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)

topic Count between values aggregated for days in QlikView

Count between values aggregated for days

Re: Count between values aggregated for days