topic Re: Expression not working properly in QlikView

Expression not working properly

deepakqlikview_123 — Mon, 06 Jul 2015 10:29:58 GMT

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,

Re: Expression not working properly

swuehl — Mon, 06 Jul 2015 10:59:49 GMT

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

Re: Expression not working properly

deepakqlikview_123 — Mon, 06 Jul 2015 11:02:50 GMT

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

Re: Expression not working properly

rubenmarin — Mon, 06 Jul 2015 11:04:31 GMT

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))

Re: Expression not working properly

deepakqlikview_123 — Mon, 06 Jul 2015 11:15:07 GMT

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

Re: Expression not working properly

Anonymous — Mon, 06 Jul 2015 11:20:39 GMT

Hi Deepak,

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

Re: Expression not working properly

rubenmarin — Mon, 06 Jul 2015 11:42:28 GMT

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)

Re: Expression not working properly

deepakqlikview_123 — Mon, 06 Jul 2015 15:06:10 GMT

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