How to suppress lines where 0 are present in a specific column?

[#1]

Hello Everybody,

I have a problem in one of my Qlikview apps.

The purpose of my application is to compare the ordered figures with the invoiced one for every of our customers.

I would like to delete every lines which there are a gap value = 0 but I have to keep all the lines to get the global result of the country.

How is it possible?

Thanks very much by advance,

Loic,

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[JonnyPoole]

Usually just put IF() expressions to evaluate to null on the dimensions or all the expressions.

I tested it out and it will work for you if you apply the if condition to all expressions:

example:

was: $(vSales_Amount_Global_Ordered)

Change to:

=if ( round($(vSales_Amount_Global_Invoiced))<>round($(vSales_Amount_Global_Ordered))  ,

$(vSales_Amount_Global_Ordered)

)

... and keep suppress missing/zeros enabled on presentation tab

Need to repeat in all expressions ( or dimension , but thats a little trickier with the cycle dimension in place)

Note...attached solution has the condition on all visible expressions

[#4]

Thanks very much for your answer,

That works fine.

Loïc,