topic Re: help with Pivot table in QlikView https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930779#M982021 <HTML><HEAD></HEAD><BODY><P>Can you attach the sample file with the data to demonstrate your requirement? Thank you.</P></BODY></HTML> Sun, 16 Aug 2015 11:52:51 GMT qlikviewwizard 2015-08-16T11:52:51Z help with Pivot table https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930777#M982018 <HTML><HEAD></HEAD><BODY><P>Hi Guys </P><P>I have&nbsp; a pivot table in which there is a field as below.</P><P></P><P>Current Output&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Required Output</P><P>Attendance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Attendance</P><P>Present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Present</P><P>Absent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Not Avaiable</P><P>Present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Present</P><P>Present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Present</SPAN></P><P>Present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Not Avaiable</SPAN></P><P>Absent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Not Avaiable</SPAN></P><P>Present&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333330154419px;">Not Avaiable</SPAN></P><P></P><P>Now here is the requirement I want only the top 3 rows which have value 'Present'&nbsp; to be shown and rest should have Not Available.</P><P></P><P>Please Help</P></BODY></HTML> Sat, 15 Aug 2015 17:43:26 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930777#M982018 Anonymous 2015-08-15T17:43:26Z Re: help with Pivot table https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930778#M982019 <HTML><HEAD></HEAD><BODY><P>Sorry, not sure if I fully understand. </P><P></P><P>I assume your 'field' is a dimension, but it's probably not the only dimension, since it's showing duplicate values (and a dimension is showing distinct values). Also not sure about your data model, expressions used etc.</P><P></P><P><SPAN style="font-size: 13.3333330154419px;">Could you upload a small sample QVW that demonstrates your issue? Would be the most efficient way, in combination with providing your requested result (e.g. as excel table, screenshot etc.).</SPAN></P></BODY></HTML> Sun, 16 Aug 2015 11:48:29 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930778#M982019 swuehl 2015-08-16T11:48:29Z Re: help with Pivot table https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930779#M982021 <HTML><HEAD></HEAD><BODY><P>Can you attach the sample file with the data to demonstrate your requirement? Thank you.</P></BODY></HTML> Sun, 16 Aug 2015 11:52:51 GMT https://community.qlik.com/t5/QlikView/help-with-Pivot-table/m-p/930779#M982021 qlikviewwizard 2015-08-16T11:52:51Z