topic Re: if the Difference between two dimension values are zero, then it should not display null value in QlikView

if the Difference between two dimension values are zero, then it should not display null value

abc_18 — Tue, 15 Dec 2015 07:47:53 GMT

Hi,

in the below image (currency rate as per NAV) and (currency rate as per TMD) are two dimensions which is used in this table, and variance is expression ie' is nothing but difference between these two dimension .

I don't want to display difference value as '0', it should hide all values in variance field where difference is zero.

I have checked suppress zero value and missing values also in presentation tab, but still getting zero values.my expression is:-

=if(isnull([NAV Exchange Rate]),0,num([NAV Exchange Rate],'####.######'))

if(isnull(TMDExchangeRate),0,num(TMDExchangeRate,'####.######'))

Re: if the Difference between two dimension values are zero, then it should not display null value

abc_18 — Tue, 15 Dec 2015 11:02:04 GMT

Hi,

just want to add one more thing, that if the difference between two column is zero, then how can we hide entire row.

Re: if the Difference between two dimension values are zero, then it should not display null value

Anonymous — Tue, 15 Dec 2015 11:22:10 GMT

If it for just you want to avoid the Null Values of a Dimension, then do like this at script levle:

if(len(trim([NAV Exchange Rate]))>0, [NAV Exchange Rate]) as [NAV Exchange Rate]

This will remove the null values of [NAV Exchange Rate]...

Re: if the Difference between two dimension values are zero, then it should not display null value

MayilVahanan — Tue, 15 Dec 2015 11:58:55 GMT

Can you able to provide sample data

Re: if the Difference between two dimension values are zero, then it should not display null value

abc_18 — Tue, 15 Dec 2015 12:08:08 GMT

Hi Balraj,

Thanks for reply.

I don't want to avoid the null value of a dimension.

My requirement is, if in expression column ie' Variance(difference of two dimension) is zero then it should hide entire row.

Re: if the Difference between two dimension values are zero, then it should not display null value

Anonymous — Tue, 15 Dec 2015 12:09:15 GMT

check this:

how to suppress rows with 0's and '-'

(VBScript) - Step by Step - Suppress Zero Values

How to skip zero values

Re: if the Difference between two dimension values are zero, then it should not display null value

abc_18 — Tue, 15 Dec 2015 12:11:13 GMT

Hi Mayil,

I have added screenshot of my requirement above.please refer same.