Nested IF Statement in Gauge Chart

Anonymous — Tue, 09 Apr 2013 20:06:47 GMT

Hello! Something is wrong with my formula in red text...

=num(If(Region = 'NA', sum({$<Term={'Actuals'}>}[Total Value])/[NA Target],
If(Region = 'ASIA', sum({$<Term = {'Actuals'}>} [Total Value])/[Asia Target],
Sum({$<Term = {'Actuals'}>} [Total Value])/([NA Target] + [Asia Target]))),'#,###.0%')

Below statement did not work...Instead of dividing Total Value against Asia Target, it calculates against NA+Asia Target which is not the goal....

Note : Asia and NA Target came from Input box

My objectives are :

1. If I select the NA in region object, this will calculate the Total actuals in NA / NA Target -

Note : there is no problem

2.. If I select the Asia in region object, this will calculate the Total actuals in Asia / Asia Target

Note : It doesn't work... Instead of dividing Total Value against Asia Target, it calculates against NA+Asia Target

3. If I select both NA and Asia, this will calculate the Total actuals in Asia and NA / Asia Target + NA Target -

Note : ok no rpoblem

Pls. help...

Tks.

topic Nested IF Statement in Gauge Chart in QlikView

Nested IF Statement in Gauge Chart