use chart expression value

[kobikobi]

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

[MK_QSL]

Can you share your data?

[#3]

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

[kobikobi]

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

[#5]

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

Cheers,

Lucas

[#6]

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

Cheers,

Lucas

[kobikobi]

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

thanks

Kobi

[SunilChauhan]

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

[kobikobi]

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