topic Re: Top 3 Values in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Top-3-Values-in-Pivot-Table/m-p/695659#M251432 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA an example.</P><P></P><P>Use Rank() function</P><P></P><P>First expression</P><P><SPAN style="color: #0433ff;">IF</SPAN>(<SPAN style="color: #0433ff;">RANK</SPAN>(<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales1</SPAN>))&lt;=3,<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales1</SPAN>)) </P><P>Second</P><P><SPAN style="color: #0433ff;">IF</SPAN>(<SPAN style="color: #0433ff;">RANK</SPAN>(<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales2</SPAN>))&lt;=3,<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales2</SPAN>)) </P></BODY></HTML> Thu, 17 Jul 2014 09:09:15 GMT SergeyMak 2014-07-17T09:09:15Z Top 3 Values in Pivot Table https://community.qlik.com/t5/QlikView/Top-3-Values-in-Pivot-Table/m-p/695658#M251431 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>First of all I want to say sorry to posting this question again which is already asked by several times.</P><P>But I am not able to get the top 3 values in pivot table for one dimension and two dimension. I am attaching one sample app please some one help me regarding this.</P><P></P><P>Thanks in advance..</P></BODY></HTML> Thu, 17 Jul 2014 09:03:54 GMT https://community.qlik.com/t5/QlikView/Top-3-Values-in-Pivot-Table/m-p/695658#M251431 soha1902 2014-07-17T09:03:54Z Re: Top 3 Values in Pivot Table https://community.qlik.com/t5/QlikView/Top-3-Values-in-Pivot-Table/m-p/695659#M251432 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA an example.</P><P></P><P>Use Rank() function</P><P></P><P>First expression</P><P><SPAN style="color: #0433ff;">IF</SPAN>(<SPAN style="color: #0433ff;">RANK</SPAN>(<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales1</SPAN>))&lt;=3,<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales1</SPAN>)) </P><P>Second</P><P><SPAN style="color: #0433ff;">IF</SPAN>(<SPAN style="color: #0433ff;">RANK</SPAN>(<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales2</SPAN>))&lt;=3,<SPAN style="color: #0433ff;">Sum</SPAN>(<SPAN style="color: #941100;">Sales2</SPAN>)) </P></BODY></HTML> Thu, 17 Jul 2014 09:09:15 GMT https://community.qlik.com/t5/QlikView/Top-3-Values-in-Pivot-Table/m-p/695659#M251432 SergeyMak 2014-07-17T09:09:15Z