Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Specialist II
Specialist II

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