Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Take a look at the blog posts also.
HIC