topic Re: Removing expression from straight table in QlikView

Removing expression from straight table

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to remove an all fields from a straight table for when the quantity is 0.

The expression for Quantity is: sum([Vehicle Rev Qty])

The only way I know how to usually remove them is by ticking 'Suppress Zero Values', but that isnt doing anything in this occasion.

Any ideas on the best way to do it?

Re: Removing expression from straight table

MK_QSL — Tue, 24 Jan 2017 15:10:04 GMT

May be try below one

sum({<YourDimensionName = {"=SUM([Vehicle Rev Qty])>0"}>}[Vehicle Rev Qty])

Re: Removing expression from straight table

sunny_talwar — Tue, 24 Jan 2017 15:10:43 GMT

Do you have more than one expressions? May be you need to force the other values in this row to be null or 0 also. Let Say you have another expression as Count(Measure)... you can do like this

If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))

Repeat this for all your expresisons... and then 'Suppress Zero Value' should work

Re: Removing expression from straight table

krishnacbe — Tue, 24 Jan 2017 15:15:30 GMT

Hi,

1. Uncheck "Show All Values" Check box if it is checked for any of the Dimensions.

2. Uncheck the Suppress Zero-Values

If you still see the values, share the app or image.

Re: Removing expression from straight table

satheshreddy — Tue, 24 Jan 2017 15:17:32 GMT

Hi,

Can you try to show Conditionally, like

if(Quantity>=1,1,0)

Regards

Sathish

Re: Removing expression from straight table

khaycock — Tue, 24 Jan 2017 15:37:38 GMT

This works great thanks Sunny! Is there a way I can get it to only show results when the quantity is above 0? As its given me some negative results that I dont need

Re: Removing expression from straight table

sunny_talwar — Tue, 24 Jan 2017 15:38:55 GMT

That is strange because I was looking for only quantities above 0

If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))

Did you check with <> may be?