topic Re: expression is not returning correct values against dimension. in QlikView

expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 07:40:34 GMT

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

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:14:28 GMT

Nadeem -

It seems that except your variable vGet5Score no other variable is working right now. You will need to fix all your variable to get to the result you are looking for. Each variable in itself is a complicated expression which we won't know what you are trying to calculate.

Sunny

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:19:42 GMT

Hi,

Thanks for replying i have tested the variables they are working fine in my app .

The text box with the title total score has all the variables in it and it is working as desired

Regards,

Nadeem

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:23:27 GMT

Please see attached the table

and the text box:

Both these are values from just one variable vGet5Score

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:37:17 GMT

Hi ,

Please check my screenshot.

I am attaching the app once again

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:40:44 GMT

There is no attachment in the most recent post, did you replaced the attachment at the top?

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:42:00 GMT

Yes I did replace it

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:45:02 GMT

Its weird, but it still isn't showing me any information for those columns

Not sure why its doing this

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:47:31 GMT

Looking at this, it seems your variable is returning the same values over and over again instead of probably showing different values for different regions. Still feel variable isn't doing what you are hoping it would do

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:47:54 GMT

Ok I got the problem the issue is with the date if you could set ur computers DATE to 30-04-2015

then it will show data as it has MTD data in it

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:52:02 GMT

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

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:55:05 GMT

the variable is just not working in the chart

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:55:13 GMT

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

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:56:11 GMT

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

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 09:57:07 GMT

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

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:58:09 GMT

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

Re: expression is not returning correct values against dimension.

sunny_talwar — Fri, 01 May 2015 09:58:48 GMT

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

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 10:02:07 GMT

Nope i am still getting the same result

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 10:03:36 GMT

I already tried this but still same issue .

Reagards

Nadeem

Re: expression is not returning correct values against dimension.

fashid — Fri, 01 May 2015 10:04:44 GMT

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