topic how to suppress grid rows based on value in QlikView

how to suppress grid rows based on value

Mon, 19 Oct 2015 15:23:28 GMT

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 — Fri, 23 Oct 2015 12:18:18 GMT

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

Fri, 23 Oct 2015 12:22:51 GMT

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 — Fri, 23 Oct 2015 12:40:35 GMT

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))