topic Re: Selectively display data in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052075#M353020 <HTML><HEAD></HEAD><BODY><P>Thank you, swuehl. It works.</P></BODY></HTML> Tue, 22 Mar 2016 23:07:29 GMT 2016-03-22T23:07:29Z Selectively display data in a pivot table https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052073#M353018 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">I have a data file as shown on the left, i would like to display it in a pivot table as shown on the right.</SPAN></P><P><IMG alt="data.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/119049_data.PNG" style="height: auto;" />&nbsp; <IMG alt="table.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/119048_table.PNG" style="height: auto;" /></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 12pt;">My question is how do i selectively display the price according to the Volume.</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 12pt;">e.g. For Prod1, Cust1 and S1, there are two rows, shown as below. </SPAN><SPAN style="font-size: 12pt;">I only want to display the price (0.352) which has bigger volume.</SPAN></P><P style="font-size: 13.3333px;"><IMG alt="example.PNG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/119051_example.PNG" /></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 12pt;">Thank you in advance for your help!</SPAN></P></BODY></HTML> Tue, 22 Mar 2016 22:42:07 GMT https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052073#M353018 2016-03-22T22:42:07Z Re: Selectively display data in a pivot table https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052074#M353019 <HTML><HEAD></HEAD><BODY><P>Try something like</P><P></P><P>=FirstSortedValue(DISTINCT Price, -Volume)</P><P></P><P>as your expression with the three dimensions mentioned above.</P></BODY></HTML> Tue, 22 Mar 2016 22:53:51 GMT https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052074#M353019 swuehl 2016-03-22T22:53:51Z Re: Selectively display data in a pivot table https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052075#M353020 <HTML><HEAD></HEAD><BODY><P>Thank you, swuehl. It works.</P></BODY></HTML> Tue, 22 Mar 2016 23:07:29 GMT https://community.qlik.com/t5/QlikView/Selectively-display-data-in-a-pivot-table/m-p/1052075#M353020 2016-03-22T23:07:29Z