topic Re: use chart expression value in QlikView

use chart expression value

kobikobi — Wed, 12 Mar 2014 13:25:34 GMT

I want to use a value that had been calculated from chart expression .

I use an avg(Score) and a hierarchy dimension so if the chart show avg of 3 current selection value , i want to use each one of them.

their is any idea how to get thus value?

thanks

kobi

Re: use chart expression value

MK_QSL — Wed, 12 Mar 2014 13:29:43 GMT

Can you share your data?

Re: use chart expression value

Wed, 12 Mar 2014 13:49:23 GMT

I'm not exactly sure what you mean, but if you want to get the result you see in your chart, the formula would be:

aggr(avg(Score),dimension)

Cheers,

Lucas

Re: use chart expression value

kobikobi — Wed, 12 Mar 2014 14:11:49 GMT

I try to present each link path color based on the result shown in chart for each link

Re: use chart expression value

Wed, 12 Mar 2014 14:15:17 GMT

I can't seem to open the picture... Can you attach it?

Cheers,

Lucas

Re: use chart expression value

Wed, 12 Mar 2014 14:36:32 GMT

I don't quite exactly understand what you want... Do you want to store the chart results into a variable?

Cheers,

Lucas

Re: use chart expression value

kobikobi — Wed, 12 Mar 2014 14:45:59 GMT

yes that what i try to do but to get all the list that appear on chart after the user selection

thanks

Kobi

Re: Re: use chart expression value

SunilChauhan — Wed, 12 Mar 2014 14:56:21 GMT

Expression can be used in another expression in same Chart i.e

suppose first Expression Is Sum(amount)

and i want to calulate Amount >100,100+100,100

then

i can achive this in Next Expression Like below

if(Column(1)>100,100+100,100) and this Expression is Known as Column(2).

and again i can use this Expression into new using Column(2)

see the attched file hope this helps

hope this helps

Re: use chart expression value

kobikobi — Wed, 12 Mar 2014 15:10:57 GMT

Hi i am using a personal Qlikview edition so i can't open the App , i am sorry i didn't mention it before.

I didn't understand how its can help to calc the exact value in the chart .

In the chart i use an hierarchical dimension VehicleType-->LinkID and the expression is Avg(Score)

i failed to calc the same value follow the current selection

thanks for your help

Kobi