expression is not returning correct values against dimension.

[fashid]

Hi Friends,

I need a help with an expression in my chart.

I have several parameters and their associated MTD scores in my application.which is shown in a chart.

Now I have created a straight table which gives me the total score of all the parameters.

Now the the problem the total score is getting calculated correctly but its not showing according to the branch dimension which i have used in the chart.

Could anybody point out what the issue could be.

I am attaching my sample app and the expected output.

Regards

Nadeem

[fashid]

Yeah true but the thing is that when i use the content of the variable directly in the chart then it works perfect.

[fashid]

the variable is just not working in the chart

[sunny_talwar]

May be the dollar sign expansion will help:

=SUM(Aggr(if(isnull(vBillTatScore),0,$(vBillTatScore))

+

if(IsNull(vClaimsFreeScore),0,$(vClaimsFreeScore))

+

if(IsNull(vEnq4score),0,$(vEnq4score))

+

if(IsNull(vEnqOtherScore),0,$(vEnqOtherScore))

+

if(IsNull(vConversionScore),0,$(vConversionScore))

+

if(IsNull(vGet5Score),0,$(vGet5Score)),BRANCH_NAME))

[sunny_talwar]

I tried this, but it did not work, may be I have to restart which will take forever to do. So lets see if we can fix it without me needing to restart

[fashid]

if u set ur computer's date to 30-04-2015 it will work

[sunny_talwar]

Just to be on the safe side, just try this instead of the one I sent before this one:

=SUM(Aggr(if(isnull($(vBillTatScore)),0,$(vBillTatScore))

+

if(IsNull($(vClaimsFreeScore)),0,$(vClaimsFreeScore))

+

if(IsNull($(vEnq4score)),0,$(vEnq4score))

+

if(IsNull($(vEnqOtherScore)),0,$(vEnqOtherScore))

+

if(IsNull($(vConversionScore)),0,$(vConversionScore))

+

if(IsNull($(vGet5Score)),0,$(vGet5Score)),BRANCH_NAME))

[sunny_talwar]

I did but nothing happened. I might need to restart which I don't want to do...

[fashid]

Nope i am still getting the same result

[fashid]

I already tried this but still same issue .

Reagards

Nadeem

[fashid]

you do not need to restart you just need to reopen the qvw after setting the date to 30-04-2015