topic Re: How to filter data in an existing table in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114569#M765854 <HTML><HEAD></HEAD><BODY><P>If your "Difference log vs Survey" calculation condition is like: ColumnA - ColumnB.</P><P>modify it like: If((ColumnA-ColumnB) &gt; 10, (ColumnA-ColumnB)).</P></BODY></HTML> Thu, 05 Jul 2018 16:00:58 GMT BalaBhaskar_Qlik 2018-07-05T16:00:58Z How to filter data in an existing table https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114567#M765852 <HTML><HEAD></HEAD><BODY><P>I need to show records for data where the difference log is more than 10.How can I use filter in this respect.</P><P>Please refer to the attached image for the set of records</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114567#M765852 trishita 2020-11-25T16:16:04Z Re: How to filter data in an existing table https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114568#M765853 <HTML><HEAD></HEAD><BODY><P>create a flag in script like below</P><P></P><P>if((Difference log vs)&gt;10,'&gt;10','&lt;10') as MOrethan10</P></BODY></HTML> Thu, 05 Jul 2018 13:43:20 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114568#M765853 rajeshqvd 2018-07-05T13:43:20Z Re: How to filter data in an existing table https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114569#M765854 <HTML><HEAD></HEAD><BODY><P>If your "Difference log vs Survey" calculation condition is like: ColumnA - ColumnB.</P><P>modify it like: If((ColumnA-ColumnB) &gt; 10, (ColumnA-ColumnB)).</P></BODY></HTML> Thu, 05 Jul 2018 16:00:58 GMT https://community.qlik.com/t5/QlikView/How-to-filter-data-in-an-existing-table/m-p/114569#M765854 BalaBhaskar_Qlik 2018-07-05T16:00:58Z