topic Re: How to delete data in fields through script in QlikView https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588956#M738906 <P>don't know your expression but use set analysis</P><P>sum({&lt;Dim2 -={'Jamnagar'}&gt;} value)</P><P>Regards</P> Thu, 06 Jun 2019 11:11:00 GMT martinpohl 2019-06-06T11:11:00Z How to delete data in fields through script https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588951#M738904 <P>Hi all,</P><P>I have a pivot table (file attached),here i dont want to show&nbsp; specific value&nbsp; in pivot table,is there any option to not to show this value in table?</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588951#M738904 venkat1 2020-11-25T16:16:04Z Re: How to delete data in fields through script https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588955#M738905 <P>There are the few options:<BR />1. Use Set analysis<BR />2. Remove it while loading data with Where statement<BR />3. Use Sheet Triggers to ignore it</P> Thu, 06 Jun 2019 11:11:00 GMT https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588955#M738905 MindaugasBacius 2019-06-06T11:11:00Z Re: How to delete data in fields through script https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588956#M738906 <P>don't know your expression but use set analysis</P><P>sum({&lt;Dim2 -={'Jamnagar'}&gt;} value)</P><P>Regards</P> Thu, 06 Jun 2019 11:11:00 GMT https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588956#M738906 martinpohl 2019-06-06T11:11:00Z Re: How to delete data in fields through script https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588980#M738907 <P>Can you please expalaim me on removing by where statement and sheet triggers?</P><P>my data is like</P><P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>usa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SFO</P><P>uk&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; scot</P><P>usa&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <STRONG>&nbsp;SFO</STRONG></P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;texas</P><P>here i want to remove sfo from third&nbsp; row .</P><P>&nbsp;</P> Thu, 06 Jun 2019 11:35:37 GMT https://community.qlik.com/t5/QlikView/How-to-delete-data-in-fields-through-script/m-p/1588980#M738907 venkat1 2019-06-06T11:35:37Z