topic Re: Conditional Expression not hiding value in QlikView

Conditional Expression not hiding value

Tue, 17 Sep 2013 13:56:18 GMT

Hello,

When trying to hide an expression on a conditional statement - I find that if I put a 0 in the expression the rows are hidden, if I put a expression (such as =if(count({<[sdk_syncs]={">0"},os_platform_key={3},[market_data]={'Market'}>} distinct_row_key) > 0, 1 ,0)) the rows are displayed - even when the expression evaluates to 0.

So in the following table:

May-2011	22	0
Jun-2011	32	0
Jul-2011	59	0
Aug-2011	82	0
Sep-2011	122	0
Oct-2011	211	0
Nov-2011	299	0
Dec-2011	404	0
Jan-2012	525	1
Feb-2012	658	1
Mar-2012	827	1
Apr-2012	999	1

The rows from May-2011 until Dec -2011 should not show up - but they are.

Any ideas?

Re: Conditional Expression not hiding value

Gysbert_Wassenaar — Tue, 17 Sep 2013 14:00:55 GMT

Try only({<[sdk_syncs]={">0"},os_platform_key={3},[market_data]={'Market'}>}1)

Re: Conditional Expression not hiding value

Clever_Anjos — Tue, 17 Sep 2013 14:05:50 GMT

On second column use an "if" to return 0 and mark "Supress zero values" at Presentation tab

example (second column)

if(count({<[sdk_syncs]={">0"},os_platform_key={3},[market_data]={'Market'}>} distinct_row_key) > 0,

[second column expression]

,0))