topic Re: Same expression but different result in QlikView

Same expression but different result

cbaqir — Thu, 14 Jul 2016 17:58:45 GMT

Hi all,

I have a combo chart that displays data for a variable:

vNewForecastAccuracy

IF(($(vForecastRound)=0 and $(vActualRound)=0),0,IF(FABS($(vNewVariance))>1,0,1-FABS(($(vNewVariance)))))

I wasn't sure why Q4 was showing 0 so I pulled it into a table and the other three Qs match but Q4 shows 2.1%.

The charts have the same exact expression so why would these be different? It's almost as if the "if statement" (IF(FABS($(vNewVariance))>1,0,1-FABS(($(vNewVariance)) is applying to the first chart but not to the second and I cannot figure out why.

vNewVariance

IF($(vVariance)=0,0,IF($(vForecastRound)=0,IF($(vVariance)<0,-1,1), ($(vVariance)/ ($(vForecastRound)))))

Any help would be appreciated.

Thanks,

Cassandra

Re: Same expression but different result

alexpanjhc — Thu, 14 Jul 2016 18:26:23 GMT

to me, i think this is correct.

for 16Q4

your FABS($(vNewVariance)) is actually greater than 1, for that reason, your forecast actual should be 0. ---your vNewVariance seems to be the Variance%, correct?

Re: Same expression but different result

sunny_talwar — Thu, 14 Jul 2016 18:28:43 GMT

Would you be able to share a sample of what you have?

Re: Same expression but different result

cbaqir — Thu, 14 Jul 2016 20:22:49 GMT

But why would it be a different result in two different places?

Re: Same expression but different result

swuehl — Thu, 14 Jul 2016 20:39:53 GMT

Are you sure you are operating on the same record set (including active selections made) and are using the same dimension and expression in both charts?

Re: Same expression but different result

alexpanjhc — Thu, 14 Jul 2016 21:46:00 GMT

Try 2 tests

1) put the variance% in the second chart see the result

2) remove the variance% from the second chart and create a text object and use the vNewVariance formula there and see result?

Re: Same expression but different result

Anonymous — Mon, 18 Jul 2016 13:00:29 GMT

We can better assist you if we have any sample app.