topic How to show only slected data in a pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452647#M818299 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please advise me how I could restrict the condition below.</P><P></P><P>As per data given in the pivot table&nbsp; below, I need to show data only for ACCOUNT_CODE 37440, 37500,37460 &amp; 37110 &amp; data on other codes to be excluded from appearing in the table!</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174427_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks</P><P>Neville</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT nevilledhamsiri 2020-11-25T16:16:04Z How to show only slected data in a pivot table https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452647#M818299 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Please advise me how I could restrict the condition below.</P><P></P><P>As per data given in the pivot table&nbsp; below, I need to show data only for ACCOUNT_CODE 37440, 37500,37460 &amp; 37110 &amp; data on other codes to be excluded from appearing in the table!</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174427_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thanks</P><P>Neville</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452647#M818299 nevilledhamsiri 2020-11-25T16:16:04Z Re: How to show only slected data in a pivot table https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452648#M818300 <HTML><HEAD></HEAD><BODY><P>Use set analysis in all your expressions</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>{&lt;ACCOUNT_CODE = {37440, 37500,37460, 37110}&gt;}</STRONG></SPAN></P></BODY></HTML> Wed, 23 Aug 2017 19:07:16 GMT https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452648#M818300 sunny_talwar 2017-08-23T19:07:16Z Re: How to show only slected data in a pivot table https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452649#M818301 <HTML><HEAD></HEAD><BODY><P>Your Question title says selected data so, you mean there is a possibility that you might select different accountCodes or only these 4 codes you mentioned? </P></BODY></HTML> Thu, 24 Aug 2017 14:52:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452649#M818301 vishsaggi 2017-08-24T14:52:23Z Re: How to show only slected data in a pivot table https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452650#M818302 <HTML><HEAD></HEAD><BODY><P>Only four codes given</P></BODY></HTML> Thu, 24 Aug 2017 17:34:10 GMT https://community.qlik.com/t5/QlikView/How-to-show-only-slected-data-in-a-pivot-table/m-p/1452650#M818302 nevilledhamsiri 2017-08-24T17:34:10Z