Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set expression of all the values with a given dimension

I have 3 dimensions: Name, Title and Score; and their table boxes.

I want to write an expression for my chart as: the average of all scores of all the names whose Title is the current selected one.

How do i do that in set analysis?

Tags (2)
1 Solution

Accepted Solutions
lironbaram
Honored Contributor II

Set expression of all the values with a given dimension

ok now i under stand

if fairly simple set analysis

avg({<Name=,Title=P(Title)>}Score) will bring back the desired result

4 Replies
lironbaram
Honored Contributor II

Set expression of all the values with a given dimension

hey maybe  i didn't quite understood your problem

those your dimension in the same table

in that case why do you need set analysis ,when the user select a title

the function avg(Score) will return the avg of all scores of names with the selected title

if you want the avg of all names scores you can go with avg(aggr(avg(Score),Name))

hope it helps you

Not applicable

Set expression of all the values with a given dimension

Hello,

Thank you for your reply. I think i could not express myself clearly.

Indeed what i want to do is , when user selects a name (lets say the name is Liron and his title is manager)

I want to calculate the avarage score of all the other names that belongs to the manager title.

avg(score) returns only the avarage score of Liron over other dimentions.

I couldnt figure out what avg(aggr(avg(Score),Name)) does, but it also do the calculation only over Liron.

Thanks.

lironbaram
Honored Contributor II

Set expression of all the values with a given dimension

ok now i under stand

if fairly simple set analysis

avg({<Name=,Title=P(Title)>}Score) will bring back the desired result

Not applicable

Set expression of all the values with a given dimension

yes that works! Thank you very much!!

Community Browser