topic Re: First 5 values in Pivot Table and insert blank values in QlikView https://community.qlik.com/t5/QlikView/First-5-values-in-Pivot-Table-and-insert-blank-values/m-p/572975#M1104506 <HTML><HEAD></HEAD><BODY><P>As some countries don't have 5 fruits, you have to first link all fruits to all countries in script level with 0 sale or qty.</P><P>After this you can use Rank function to display them as per your requirements.</P></BODY></HTML> Fri, 28 Mar 2014 07:17:10 GMT MK_QSL 2014-03-28T07:17:10Z First 5 values in Pivot Table and insert blank values https://community.qlik.com/t5/QlikView/First-5-values-in-Pivot-Table-and-insert-blank-values/m-p/572974#M1104505 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi All,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Can any suggest this scenario.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I have a pivot table Country, Fruits and Amount. Here first I have to show first 5 fruits for each country .Second, countries like SG and UK doest have 5 fruits (3 and 4 resp) here I have to show blank field with no amount (see attached image)</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">(See attached QVW and Excel input).</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Regards,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tom</SPAN></P></BODY></HTML> Fri, 28 Mar 2014 06:41:21 GMT https://community.qlik.com/t5/QlikView/First-5-values-in-Pivot-Table-and-insert-blank-values/m-p/572974#M1104505 thomas_skariah 2014-03-28T06:41:21Z Re: First 5 values in Pivot Table and insert blank values https://community.qlik.com/t5/QlikView/First-5-values-in-Pivot-Table-and-insert-blank-values/m-p/572975#M1104506 <HTML><HEAD></HEAD><BODY><P>As some countries don't have 5 fruits, you have to first link all fruits to all countries in script level with 0 sale or qty.</P><P>After this you can use Rank function to display them as per your requirements.</P></BODY></HTML> Fri, 28 Mar 2014 07:17:10 GMT https://community.qlik.com/t5/QlikView/First-5-values-in-Pivot-Table-and-insert-blank-values/m-p/572975#M1104506 MK_QSL 2014-03-28T07:17:10Z