topic Re: Hide rows where expression is zero in QlikView

Hide rows where expression is zero

Wed, 16 Nov 2011 11:48:17 GMT

Hi,

could You help me hide rows where expression is 0. See example below.

jagannalla — Wed, 16 Nov 2011 11:56:30 GMT

I gone through your application. Can you clear me once again whether you want to hide column or row. B'coz all rows have the data.

swuehl — Wed, 16 Nov 2011 11:56:56 GMT

Maybe like attached? I assumed you want to hide row where expression column3 is zero.

Hope this helps,

Stefan

rohit214 — Wed, 16 Nov 2011 11:57:06 GMT

hi Tichan

which expressiion you are talking about..

and one more this whish row you want to hide where value1 or Value2 0 or null

or value1+value2=0

thanks

rohit

lironbaram — Wed, 16 Nov 2011 11:58:05 GMT

hei

attach is an example with two methods

the upper one is using a condition in all the expressions

the lower one is checking the condition in the dimension once

Wed, 16 Nov 2011 12:21:06 GMT

Hi,

your solution is also OK, but swuehl's solution is better for my report.

Wed, 24 Oct 2012 21:49:23 GMT

can you put it on this please?

salto — Thu, 20 Nov 2014 11:14:28 GMT

This has helped me in a problem I was suffering right now. Thanks!