topic Pivot table: fill only based on a specific field's value in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484340#M180910 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table containing data to compare the values of the last three weeks. For this, I added a field called EXTRACT_WEEKNAME to the existing data.</P><P></P><P>So I have something like</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp; EXTRACT_WEEKNAME</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/44</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 650€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/45</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/44</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/45</P><P></P><P>How can I set up a pivot table that only shows the lastest entries (meaning latest EXTRACT_WEEKNAME)?</P><P></P><P>Thanks,.</P></BODY></HTML> Wed, 06 Nov 2013 07:37:49 GMT 2013-11-06T07:37:49Z Pivot table: fill only based on a specific field's value https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484340#M180910 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table containing data to compare the values of the last three weeks. For this, I added a field called EXTRACT_WEEKNAME to the existing data.</P><P></P><P>So I have something like</P><P></P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp; EXTRACT_WEEKNAME</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 500€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/44</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 650€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/45</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/44</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 250€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2013/45</P><P></P><P>How can I set up a pivot table that only shows the lastest entries (meaning latest EXTRACT_WEEKNAME)?</P><P></P><P>Thanks,.</P></BODY></HTML> Wed, 06 Nov 2013 07:37:49 GMT https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484340#M180910 2013-11-06T07:37:49Z Re: Pivot table: fill only based on a specific field's value https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484341#M180911 <HTML><HEAD></HEAD><BODY><P>Anyone who can help, please <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> ?</P></BODY></HTML> Thu, 07 Nov 2013 11:11:39 GMT https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484341#M180911 2013-11-07T11:11:39Z Re: Pivot table: fill only based on a specific field's value https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484342#M180912 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Thu, 07 Nov 2013 11:20:01 GMT https://community.qlik.com/t5/QlikView/Pivot-table-fill-only-based-on-a-specific-field-s-value/m-p/484342#M180912 Gysbert_Wassenaar 2013-11-07T11:20:01Z