topic Re: How to remove zero value in straight table? in QlikView

How to remove zero value in straight table?

Mon, 11 Aug 2014 14:08:46 GMT

Hi,

emp id sal

a 1 3

b 2 5

c 3 7

i used straight table

iam getting 0 in first column

i user suppress ,missing values in property tab but still iam getting 0

please help

ashfaq_haseeb — Mon, 11 Aug 2014 14:10:17 GMT

In your expression

Try below

If(sum(sal)>0,sum(sal))

Regards

ASHFAQ

its_anandrjs — Mon, 11 Aug 2014 14:10:33 GMT

Can you explain what expression you use.

hannan_t — Mon, 11 Aug 2014 14:11:18 GMT

In dimension tab check the box "Suppress where the values are null"

its_anandrjs — Mon, 11 Aug 2014 14:12:02 GMT

Try with

If( sal > 0 , Sum(sal))

If(Sum(sal) > 0 , Sum(sal))

Or you can try with suppress values form option chart properties >> Presentation >> Suppress Zero-Values