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

Announcements
Join us in Toronto Sept 9th 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.