# 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.

Thanks for your help.

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 ?

Thanks for your response Massimo.

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