topic Re: Reference line issue in QlikView https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519462#M194027 <HTML><HEAD></HEAD><BODY><P>Oops sorry the expression I used is Max(aggr(Name,Comment/PostCount)). Forgot to add the division line. But still doesnt works.</P></BODY></HTML> Wed, 24 Jul 2013 14:53:52 GMT 2013-07-24T14:53:52Z Reference line issue https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519461#M194026 <HTML><HEAD></HEAD><BODY><P>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&nbsp; 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 </P><P></P><P>Max(aggr(Name,CommentPostCount))</P></BODY></HTML> Wed, 24 Jul 2013 14:49:22 GMT https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519461#M194026 2013-07-24T14:49:22Z Re: Reference line issue https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519462#M194027 <HTML><HEAD></HEAD><BODY><P>Oops sorry the expression I used is Max(aggr(Name,Comment/PostCount)). Forgot to add the division line. But still doesnt works.</P></BODY></HTML> Wed, 24 Jul 2013 14:53:52 GMT https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519462#M194027 2013-07-24T14:53:52Z Re: Reference line issue https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519463#M194028 <HTML><HEAD></HEAD><BODY><P>If your expression is sum(Something) then the expression for the reference line could be <EM>max({1}aggr(sum({1}Something), Name)). </EM>If you use a different expression for your y-axis values then replace it with that. Just add the {1} to ignore the selections.</P></BODY></HTML> Wed, 24 Jul 2013 14:57:20 GMT https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519463#M194028 Gysbert_Wassenaar 2013-07-24T14:57:20Z Re: Reference line issue https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519464#M194029 <HTML><HEAD></HEAD><BODY><P>Your earlier post made it work Gysbert. Max({1}Comment/PostCount)</P><P></P><P>Could you explain what exactly its doing? Is it just taking the max and keeping the first entry always?</P></BODY></HTML> Wed, 24 Jul 2013 14:59:50 GMT https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519464#M194029 2013-07-24T14:59:50Z Re: Reference line issue https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519465#M194030 <HTML><HEAD></HEAD><BODY><P>Thanks a lot BTW. Much appreciated.</P></BODY></HTML> Wed, 24 Jul 2013 15:00:08 GMT https://community.qlik.com/t5/QlikView/Reference-line-issue/m-p/519465#M194030 2013-07-24T15:00:08Z