topic Re: How to Calculate Rank from expression.. in QlikView https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181506#M382844 <HTML><HEAD></HEAD><BODY><P>use below expression</P><P></P><P>=rank(<STRONG>total</STRONG> sum(if(Dept='Sci' and Subj = 'science', Amount*10,</P><P>if(Dept='Sci' and Subj='chemi', Amount*5,Amount))),0,1)</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139381_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sun, 02 Oct 2016 08:06:46 GMT Kushal_Chawda 2016-10-02T08:06:46Z How to Calculate Rank from expression.. https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181504#M382842 <HTML><HEAD></HEAD><BODY><P>Dear friends,</P><P></P><P>I need to calculate the Rank from the expression (here i need to calculate from expression only, not from the source field and also it shouldn't be calculated in the script).</P><P>I have attached the QVW file please let me know if anyone can help me here.</P><P></P><P>Regards,</P><P>Pooja</P></BODY></HTML> Mon, 26 Sep 2016 00:23:15 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181504#M382842 2016-09-26T00:23:15Z Re: How to Calculate Rank from expression.. https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181505#M382843 <HTML><HEAD></HEAD><BODY><P>What are you expecting?</P><P></P><P>Usually, we can calculate Ranks are like below</P><P></P><P>1) Rank(<STRONG>Expression</STRONG>)</P><P>2) Set Rank</P><P>3) From script you can try this too</P><P><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: small;">if(<STRONG>Expression</STRONG>=previous(<SPAN style="color: #222222; font-family: arial, sans-serif; font-size: small;"><STRONG>Expression</STRONG></SPAN>)</SPAN><SPAN style="color: #222222; font-family: arial, sans-serif; font-size: small;">,peek('Rank')+1,1) as Rank</SPAN></P></BODY></HTML> Sun, 02 Oct 2016 07:17:52 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181505#M382843 Anil_Babu_Samineni 2016-10-02T07:17:52Z Re: How to Calculate Rank from expression.. https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181506#M382844 <HTML><HEAD></HEAD><BODY><P>use below expression</P><P></P><P>=rank(<STRONG>total</STRONG> sum(if(Dept='Sci' and Subj = 'science', Amount*10,</P><P>if(Dept='Sci' and Subj='chemi', Amount*5,Amount))),0,1)</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139381_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Sun, 02 Oct 2016 08:06:46 GMT https://community.qlik.com/t5/QlikView/How-to-Calculate-Rank-from-expression/m-p/1181506#M382844 Kushal_Chawda 2016-10-02T08:06:46Z