Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reference line issue

I am trying to use a reference line for the maximum influence rank. I have names on the y axis and rank on the x axis. Its a vertical bar chart. I dont want to just put a number in the expression where reference line is calculated as it can move. Also I dont want to have the reference line moves if I click on a name  but I want it to be static at the Max rank all the time so as to compare. Any help is much appreciated? I have used this expression but with no luck

Max(aggr(Name,CommentPostCount))

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If your expression is sum(Something) then the expression for the reference line could be max({1}aggr(sum({1}Something), Name)). If you use a different expression for your y-axis values then replace it with that. Just add the {1} to ignore the selections.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable
Author

Oops sorry the expression I used is Max(aggr(Name,Comment/PostCount)). Forgot to add the division line. But still doesnt works.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

If your expression is sum(Something) then the expression for the reference line could be max({1}aggr(sum({1}Something), Name)). If you use a different expression for your y-axis values then replace it with that. Just add the {1} to ignore the selections.


talk is cheap, supply exceeds demand
Not applicable
Author

Your earlier post made it work Gysbert. Max({1}Comment/PostCount)

Could you explain what exactly its doing? Is it just taking the max and keeping the first entry always?

Not applicable
Author

Thanks a lot BTW. Much appreciated.