Conditional filter

[monica]

hey

I am new to qlik sense and I have a question related to conditional formatting.

I have a pivot table with numerical values for student marks that are in percentages and I would like only to show values that are equal or greater than 80%.

Your assistance will be greatly appreciated.

[Somasundaram]

Hi,

If you want to show/hide column based on the filter-- You can specify condition here show column if  =condition

If you want to show/hide values based on the filter-- You can specify condition Text color expression. =if(condition,black, white).

Hope it will help

[monica]

Hi Somasundaram

I want to hide rows that have values of less than 80%.If you can may you please assist with the expression .

Thanks

[Somasundaram]

Use your condition  =If(more than 80%,field)