QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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.

1 Solution

Accepted Solutions
Highlighted 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

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

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

=Sum(

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

,Date))

Contributor

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

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

Contributor

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

Thanks you Gabriel !! MVP

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

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