Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

suzel404
Contributor

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
Highlighted
Employee
Employee

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

=Sum(

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

        ,Date))

5 Replies
MVP
MVP

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

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

Highlighted
Employee
Employee

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

=Sum(

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

        ,Date))

suzel404
Contributor

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


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
Contributor

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

Thanks you Gabriel !!

MVP
MVP

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

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