topic Re: How to neglect two months data based on condition in QlikView https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359208#M823993 <HTML><HEAD></HEAD><BODY><P>You can use set analyis for excluding the months</P></BODY></HTML> Mon, 24 Jul 2017 10:19:24 GMT shiveshsingh 2017-07-24T10:19:24Z How to neglect two months data based on condition https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359205#M823990 <HTML><HEAD></HEAD><BODY><P>In excel i have date data from Oct-16 to Jun-17.</P><P></P><P>In Dashboard UI part I just want to show data from Dec-16 to Jun-17, how to achieve this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359205#M823990 abc_18 2020-11-25T16:16:04Z Re: How to neglect two months data based on condition https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359206#M823991 <HTML><HEAD></HEAD><BODY><P>Either limit the load so the values aren't imported OR use set analysis so they are not displayed.</P><P></P><P></P><P></P><P>Andy</P></BODY></HTML> Mon, 24 Jul 2017 10:04:12 GMT https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359206#M823991 awhitfield 2017-07-24T10:04:12Z Re: How to neglect two months data based on condition https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359207#M823992 <HTML><HEAD></HEAD><BODY><P>You need to exclude in script using where exists or not exists as per data available </P></BODY></HTML> Mon, 24 Jul 2017 10:13:31 GMT https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359207#M823992 mangalsk 2017-07-24T10:13:31Z Re: How to neglect two months data based on condition https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359208#M823993 <HTML><HEAD></HEAD><BODY><P>You can use set analyis for excluding the months</P></BODY></HTML> Mon, 24 Jul 2017 10:19:24 GMT https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359208#M823993 shiveshsingh 2017-07-24T10:19:24Z Re: How to neglect two months data based on condition https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359209#M823994 <HTML><HEAD></HEAD><BODY><P>Hello Shikha,</P><P></P><P>Below are sample solutions (please make necessary changes, if needed):</P><P>1. Script level</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Where Date &gt;= '12-01-2016'</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13.3333px;">2. KPI level</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Sum({&lt;Date={"&gt;= $(=Date#('12-01-2017', 'MM-DD-YYYY')) "}&gt;}SalesAmount)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards!</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Rahul Pawar</P></BODY></HTML> Mon, 24 Jul 2017 10:25:09 GMT https://community.qlik.com/t5/QlikView/How-to-neglect-two-months-data-based-on-condition/m-p/1359209#M823994 rahulpawarb 2017-07-24T10:25:09Z