Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suzel404
Creator
Creator

How can I count the number of time where Volume < 20 for a store ?


Hi all,

I have a store with volume and I want to know, how many times the Volume is over 20 for this store.

You can see my attachement.

Thanks for your help.

1 Solution

Accepted Solutions
GabrielAraya
Employee
Employee

=Sum(

Aggr( if(Sum(Volume)>20,1,0)

        ,Date))

View solution in original post

5 Replies
maxgro
MVP
MVP

=Sum(if(aggr(Sum(Volume),Store_id,Date)<20,1,0))

GabrielAraya
Employee
Employee

=Sum(

Aggr( if(Sum(Volume)>20,1,0)

        ,Date))

suzel404
Creator
Creator
Author


Thanks for your response Massimo.

Your expression give me 20 and not 7 like I can see in straight table to the right side.

suzel404
Creator
Creator
Author

Thanks you Gabriel !!

maxgro
MVP
MVP

you're right, I made under (<), not over