topic Re: Restricting rows in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Restricting-rows-in-Pivot-table/m-p/1389035#M820187 <HTML><HEAD></HEAD><BODY><P>May be use a calculated dimension</P><P></P><P><STRONG>If(<SPAN style="font-size: 13.3333px;">Consolidated &gt;= </SPAN>Max(TOTAL Consolidated, 5), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Consolidated)</STRONG></SPAN></P><P></P><P>and then check 'Suppress When Value Is Null' on the dimensions tab</P></BODY></HTML> Fri, 11 Aug 2017 12:16:03 GMT sunny_talwar 2017-08-11T12:16:03Z Restricting rows in Pivot table https://community.qlik.com/t5/QlikView/Restricting-rows-in-Pivot-table/m-p/1389034#M820186 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a pivot table like below. I want to show always last 5 rows.</P><P>Can you please help me to do that.</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/173167_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Thanks,</P><P>Sarif</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Restricting-rows-in-Pivot-table/m-p/1389034#M820186 mhmmd_srf 2020-11-25T16:16:04Z Re: Restricting rows in Pivot table https://community.qlik.com/t5/QlikView/Restricting-rows-in-Pivot-table/m-p/1389035#M820187 <HTML><HEAD></HEAD><BODY><P>May be use a calculated dimension</P><P></P><P><STRONG>If(<SPAN style="font-size: 13.3333px;">Consolidated &gt;= </SPAN>Max(TOTAL Consolidated, 5), </STRONG><SPAN style="font-size: 13.3333px;"><STRONG>Consolidated)</STRONG></SPAN></P><P></P><P>and then check 'Suppress When Value Is Null' on the dimensions tab</P></BODY></HTML> Fri, 11 Aug 2017 12:16:03 GMT https://community.qlik.com/t5/QlikView/Restricting-rows-in-Pivot-table/m-p/1389035#M820187 sunny_talwar 2017-08-11T12:16:03Z