topic Re: Filtrate according to values in QlikView

Filtrate according to values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Filtrate according to values

olivierrobin — Wed, 04 Jul 2018 13:33:26 GMT

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

Re: Filtrate according to values

sohb2015 — Wed, 04 Jul 2018 13:33:42 GMT

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.

Re: Filtrate according to values

Anonymous — Wed, 04 Jul 2018 14:08:12 GMT

Hello, thank you.

You mean that i apply your formula for all columns?

Re: Filtrate according to values

olivierrobin — Wed, 04 Jul 2018 14:12:41 GMT

that's it

Re: Filtrate according to values

Anonymous — Wed, 04 Jul 2018 14:48:21 GMT

Hello,

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

Any ideas?

Thanks.

Re: Filtrate according to values

olivierrobin — Wed, 04 Jul 2018 14:51:11 GMT

can you post the formulas ?

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

Re: Filtrate according to values

Anonymous — Wed, 04 Jul 2018 15:02:58 GMT

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.