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?
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
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