topic Re: Grid Chart- Error in calculated dimension in QlikView

Grid Chart- Error in calculated dimension

Mon, 05 May 2014 09:35:49 GMT

Hi Guys,

I am trying to create a grid chart but I get the following result: "Error in Calculated dimension".
I'm not sure what I'm trying to achieve can be done so I'll be happy to get your comments on this.

I want to have 2 dimension: one is the App name and the other is a variable called vConversion, which is calculated by sum(installs)/sum(clicks).

When I define this as a calculated dimension, I recieve the above mentioned error.

Is it possible to define such a dimension? If so, how can I resolve this error?

Thank you,

Ella

Re: Grid Chart- Error in calculated dimension

bbi_mba_76 — Mon, 05 May 2014 09:50:24 GMT

Hi,

maybe you have to aggregate by App name.

Re: Grid Chart- Error in calculated dimension

Gysbert_Wassenaar — Mon, 05 May 2014 10:02:57 GMT

Try =aggr(sum(installs)/sum(clicks),AppName)

Re: Grid Chart- Error in calculated dimension

Mon, 05 May 2014 10:37:48 GMT

Hi Gysbert,

I tried =aggr($(vConversion), name) and it worked.

My only question is, doesn't that function change what I wanted to achieve?

Is the calculation being performed correctly?

On Mon, May 5, 2014 at 1:03 PM, Gysbert Wassenaar

Re: Grid Chart- Error in calculated dimension

SunilChauhan — Mon, 05 May 2014 10:40:10 GMT

use expression suggested by Gysbert in variable it self and then use variable

hope this helps

Re: Grid Chart- Error in calculated dimension

Gysbert_Wassenaar — Mon, 05 May 2014 10:42:32 GMT

If you want the ratio of the sum of installs per app and the sum of clicks per app then the calculation will be correct. The only way to make sure is to check the outcome of the calculations.