topic Re: Comparison with zero not working - Dimension in Pivot Table in QlikView

Comparison with zero not working - Dimension in Pivot Table

Tue, 01 Jul 2014 10:28:10 GMT

In some Pivot Table, I have one calculated dimension based on value for an expression.

=IF([Expenses $(=(vCurrentYear)-2)] = '0', 'None', 'E')

with Expenses $(=(vCurrentYear)-2) the Label for an expression in the Pivot Table.

It gives E for all fields, so that I guess the comparison to '0' is not working (it should sometimes give None). Null() is not correct either.

How can I solve ?

Re: Comparison with zero not working - Dimension in Pivot Table

alexandros17 — Tue, 01 Jul 2014 10:33:21 GMT

Unfortunately you cannot use a label referencing a variable in expressions. so you must repeat the code in the other expression ...

Re: Comparison with zero not working - Dimension in Pivot Table

Tue, 01 Jul 2014 10:34:36 GMT

Thanks

If i repeat the code, like this

=IF(Sum({<[Fiscal Year]={$(=(vCurrentYear)-2)}>}[Sales Amount]) = '0', 'None', 'E')

this is not working (error in calculating expression). How is syntax wrong ?

Re: Comparison with zero not working - Dimension in Pivot Table

sasikanth — Tue, 01 Jul 2014 10:38:24 GMT

Try some thing like this

=IF(isNull(Sum({<[Fiscal Year]={$(=(vCurrentYear)-2)}>}[Sales Amount])),'None','E')

Re: Comparison with zero not working - Dimension in Pivot Table

Tue, 01 Jul 2014 10:38:46 GMT

try this

=IF(Sum({<[Fiscal Year]={$(=(vCurrentYear)-2)}>}[Sales Amount]) = 0, 'None', 'E')

Thank you

Vardhan

Re: Comparison with zero not working - Dimension in Pivot Table

Tue, 01 Jul 2014 11:16:30 GMT

both give error in calculated dimension

for the expression itself seems to be =IF($(=Sum({<[Fiscal Year]={$(=(vCurrentYear)-2)}>}[Sales Amount])) = 0, 'None',$(=(vCurrentYear-2)) ) but comparison with zero is still not working.

any idea?