Expression not working properly

[deepakqlikview_123]

Hi All,

PFA

If there are more than 1 indicator expression is not working properly,I have attached sample data and QVW for this.

It is not showing anything on chart

thanks,

[swuehl]

If you are talking about the Main tab chart, check your calculated dimensions, second one is limiting your indicators.

[deepakqlikview_123]

Hi,

Yes i am talking about the main tab.In calculated dimension  i could not find anything wrong we have just created variable fot calculating max year as per indicator name.

thanks

[rubenmarin1]

Hi Deepak, vYear returns more than one value, so the if() in the calculated dimension can't be calculated, maybe changing vYear to:

=max(aggr(max(YEAR),INDICATOR_NAME))

[deepakqlikview_123]

Hi Ruben,

Yes u r right,can you please suggest how to calculate max year as per specific indicator name.it gives an issue.

thanks

[Anonymous]

Hi Deepak,

I removed the aggr on the vYear variable and it seems to be working. So namely: max(YEAR)

[rubenmarin1]

Not sure but just to guess... as you're fixing only one INDICATOR_NAME in the 2nd dimension, can this expression work:

sum({<YEAR={$(=Max({<INDICATOR_NAME={'TOMGASTM Index: FOF All Sectors Total Mortgages Asset SA = All sectors; total mortgages; asset = Total Mortgages - Net Changes ($ Millions)'}>} YEAR))},FRQ_TYPE={'Q'}>}INDICATOR_VALUE)

[deepakqlikview_123]

hi thabang,

In that case it will show overall max year.

I need to calculate max year with respect ti indicator name 'TOMG

ASTM Index: FOF All Sectors Total Mortgages Asset SA = All sectors; total mortgages; asset = Total Mortgages - Net Changes ($ Millions)

and need to show data on chart wrt same indidicator by using all cases in expressions,

thnaks