Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
kobikobi
New Contributor

use chart expression value

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

8 Replies
Highlighted
MVP
MVP

Re: use chart expression value

Can you share your data?

Highlighted
Not applicable

Re: use chart expression value

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

Highlighted
kobikobi
New Contributor

Re: use chart expression value

Capture.PNG

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

Highlighted
Not applicable

Re: use chart expression value

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

Cheers,

Lucas

Highlighted
Not applicable

Re: use chart expression value

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

Cheers,

Lucas

Highlighted
kobikobi
New Contributor

Re: use chart expression value

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

thanks

Kobi

Highlighted
SunilChauhan
Esteemed Contributor

Re: Re: use chart expression 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

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

Highlighted
kobikobi
New Contributor

Re: use chart expression value

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