how to suppress grid rows based on value

[#1]

Hi all,

quite new to QLik and I know this should be an easy task , but I tried everything and could not get what I want.

I have a grid with many dimension and would like not to show rows that do have a specific (null) value on a certain dimension.

I tried with:

- dimension - enable conditional - isnull(myfield)

- dimension - enable conditiona - len(trim(myfield))=0

- expression - conditional (as the two above)

- dimension limits - restrict - show only Greater than - but to my surprise I relaized that even if positioned on a specific

dimension it works related to the measure of the grid

suppress null - suppress zero values...

...nothing worked!

what am I missing???

thanks in advance

regards,

Cristiano

[Gysbert_Wassenaar]

Can you post a small qlikview document that demonstrates the problem?

[#3]

Hi Gysbert,

thanks for helping.

Which qlik document could I provide in order to help?

Maybe I can setup a simple script with an inline and describe my problem?

[rubenmarin]

Hi Cristiano, the enable conditional check to show all dimension and all the expression, it's not row by row.

To make row by row you can set the condition inside the expression, ie:

If(len(trim(myfield))>0, Sum(Sales))