Set analysis query

[#1]

Hi, In the attached qvw I want the expression in the "Highest score by country" chart to be fixed irrespective of the selection. I know i need to do by set analysis and need to {1}, but not sure how to use that in this expression.

aggr(max({1}highest, country) doesn't seem to do the trick. Kindly help.

Thanks

Ram

[hic · Accepted solution]

Skip the visual cues. It's an old fashioned way to do this. Instead you can use expression attributes. The test will then be if max(total <country> ...) equals max(total ...).

For color, use e.g.

if(max({1}total <country> highest)=max({1}total highest),red())

For bold and underline (text format), use e.g.

if(max({1}total <country> highest)=max({1}total highest),'<B><U>')

HIC

[#3]

That is an eye-openeer for me. Very new to qlikview just 2 weeks old, but i learnt a lot of things today, your courtesy. Thanks a lot. Want to learn a lot more. Following you on twitter now.

[hic]

Take a look at the blog posts also.

HIC