Filtrate according to values

[Anonymous]

Hello,

I am creating a QlikView sheet and I wanted to have an answer to my question please.

I send you here the figure of my sheet.

What I wanted to do is display only aggregated marks that have accuracy values below 80%. I wanted to know how I can do that.

The accuracy values are calculated in the last column and what I was able to do is letting the cells in this column that correspond to values of accuracy> 80% empty using the null () function.

[olivierrobin]

hello

you could use your formula to display each other column only if you need it.

in each expression, put

if([aaccuracy agg..°>80%,value of the column,null())

so if all values are null, the rows won't appear

[sohb2015]

Hi,

You can put a if condition in the expression and that should work.

If( aggr(sum(actual sales),brand)<80,

     aggr(sum(actual sales),brand),0)

And then supress zero values.

Hope this helps.

[Anonymous]

Hello, thank you.

You mean that i apply your formula for all columns?

[olivierrobin]

that's it

[Anonymous]

Hello,

i tried but i notice that the calculation of values will be wrong for columns from 3 to 6.

Any ideas?

Thanks.

[olivierrobin]

can you post the formulas ?

if they refer to previous values, that could be a problem

[Anonymous]

Hello,

for accumulated sales for example whan i apply your formula there some rows that were hided. It's cool this but for accumulated sales for example the calculation of it still the same as if i did not hide them although i apply your formula also in acccumulated sales.

Thanks.