Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grid Chart- Error in calculated dimension

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

5 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

maybe you have to aggregate by App name.

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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

SunilChauhan
Champion
Champion


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

hope this helps

Sunil Chauhan
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand