topic Re: Show when <> 0 in QlikView

Show when <> 0

tmumaw — Wed, 31 Oct 2018 12:19:26 GMT

I have this pivot table where I only want to show the lines which have a value in one column (over-payments). Is there a way to do this?

Thanks

sunny_talwar — Wed, 31 Oct 2018 12:21:11 GMT

Update all your expressions to have this condition in them

If([Over-Payment] <> 0, Expression1)

If([Over-Payment] <> 0, Expression2)

If([Over-Payment] <> 0, Expression3)

...

and so on

You can leave the Over-Payment expression as is, but update all other expressions

tmumaw — Wed, 31 Oct 2018 12:30:58 GMT

Thanks Sunny it worked perfectly.....

tmumaw — Wed, 31 Oct 2018 13:45:19 GMT

Sunny,

Zero suppress does not work now.....any ideas?

sunny_talwar — Wed, 31 Oct 2018 13:47:21 GMT

Is it possible that Over-Payment is not 0, but a really small number like 0.0000152 or something like this?

tmumaw — Wed, 31 Oct 2018 13:57:40 GMT

Very small number, but should be 0

sunny_talwar — Wed, 31 Oct 2018 13:58:38 GMT

Not sure I understand? Are you saying that it is a very small number, but it should have been 0?

tmumaw — Wed, 31 Oct 2018 14:00:26 GMT

Very small number and should be made 0

sunny_talwar — Wed, 31 Oct 2018 14:03:02 GMT

May be use a Round() function or Floor()

Round(Expression, '0.01')

tmumaw — Mon, 05 Nov 2018 13:06:56 GMT

Thanks Sunny it worked