Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filtrate according to values

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.

Capture.PNG

7 Replies
olivierrobin
Specialist III
Specialist III

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
Contributor III
Contributor III

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
Not applicable
Author

Hello, thank you.

You mean that i apply your formula for all columns?

olivierrobin
Specialist III
Specialist III

that's it

Anonymous
Not applicable
Author

Hello,

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

Any ideas?

Thanks.

olivierrobin
Specialist III
Specialist III

can you post the formulas ?

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

Anonymous
Not applicable
Author

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.