topic load the data based on condition? in QlikView https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83494#M789029 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>i have one example table below like</P><P></P><P>a1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,c1</P><P>uk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp; laptop</P><P>us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1400&nbsp;&nbsp;&nbsp; tv&nbsp; </P><P>-missing-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ffffffff</P><P>-missing-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ffffffffff</P><P>India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mobile</P><P>India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sim</P><P>-missing-&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ffffffff</P><P></P><P></P><P>above table a1,b1,c1 are the fields.whiie loading time remove the missing data.</P><P>reqired output below like.</P><P></P><P style="font-size: 13.3333px;">a1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,c1</P><P style="font-size: 13.3333px;">uk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp; laptop</P><P style="font-size: 13.3333px;">us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1400&nbsp;&nbsp;&nbsp; tv&nbsp; </P><P style="font-size: 13.3333px;">India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mobile</P><P style="font-size: 13.3333px;">India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sim</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">thanks</P><P style="font-size: 13.3333px;">daisy</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT daisy1438 2020-11-25T16:16:04Z load the data based on condition? https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83494#M789029 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>i have one example table below like</P><P></P><P>a1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,c1</P><P>uk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp; laptop</P><P>us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1400&nbsp;&nbsp;&nbsp; tv&nbsp; </P><P>-missing-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ffffffff</P><P>-missing-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ffffffffff</P><P>India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mobile</P><P>India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sim</P><P>-missing-&nbsp;&nbsp;&nbsp;&nbsp; -1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ffffffff</P><P></P><P></P><P>above table a1,b1,c1 are the fields.whiie loading time remove the missing data.</P><P>reqired output below like.</P><P></P><P style="font-size: 13.3333px;">a1 ,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ,c1</P><P style="font-size: 13.3333px;">uk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp; laptop</P><P style="font-size: 13.3333px;">us&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1400&nbsp;&nbsp;&nbsp; tv&nbsp; </P><P style="font-size: 13.3333px;">India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mobile</P><P style="font-size: 13.3333px;">India&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sim</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">thanks</P><P style="font-size: 13.3333px;">daisy</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83494#M789029 daisy1438 2020-11-25T16:16:04Z Re: load the data based on condition? https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83495#M789030 <HTML><HEAD></HEAD><BODY><P>Load Script? Try this</P><P></P><P><STRONG>Load * From Table Where a1 &lt;&gt; '-missing';</STRONG></P></BODY></HTML> Sat, 10 Feb 2018 20:00:13 GMT https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83495#M789030 Anil_Babu_Samineni 2018-02-10T20:00:13Z Re: load the data based on condition? https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83496#M789031 <HTML><HEAD></HEAD><BODY><P>load * </P><P>from T where a1 &lt;&gt; '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">-missing- '</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Are you giving it a try?</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Your response is not coming in your previous posts!</SPAN></P></BODY></HTML> Sun, 11 Feb 2018 02:43:20 GMT https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83496#M789031 shiveshsingh 2018-02-11T02:43:20Z Re: load the data based on condition? https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83497#M789032 <HTML><HEAD></HEAD><BODY><P>Try this way</P><P>while loading data Enable Data Transformation and select the "Remove the selected Record" that will remove the missing and you can load the data as per your out put.</P></BODY></HTML> Mon, 12 Feb 2018 12:03:02 GMT https://community.qlik.com/t5/QlikView/load-the-data-based-on-condition/m-p/83497#M789032 Anonymous 2018-02-12T12:03:02Z