Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you share your data?
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
I try to present each link path color based on the result shown in chart for each link
I can't seem to open the picture... Can you attach it?
Cheers,
Lucas
I don't quite exactly understand what you want... Do you want to store the chart results into a variable?
Cheers,
Lucas
yes that what i try to do but to get all the list that appear on chart after the user selection
thanks
Kobi
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
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