topic Re: Filter Data while loading in QlikView https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144462#M374650 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please see this</P><P></P><P><A href="https://community.qlikview.com/thread/143215" title="https://community.qlikview.com/thread/143215">How to filter a data from qvd with optimized load? | Qlik Community</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Mon, 05 Sep 2016 10:35:07 GMT agomes1971 2016-09-05T10:35:07Z Filter Data while loading https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144461#M374649 <HTML><HEAD></HEAD><BODY><P>How to filter data while loading a qvd without using where clause. For example I have a field named state and I want to load data only for "<STRONG>ORISSA</STRONG>" without using where clause. How will I do that?</P></BODY></HTML> Mon, 05 Sep 2016 10:18:02 GMT https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144461#M374649 pkpandey 2016-09-05T10:18:02Z Re: Filter Data while loading https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144462#M374650 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please see this</P><P></P><P><A href="https://community.qlikview.com/thread/143215" title="https://community.qlikview.com/thread/143215">How to filter a data from qvd with optimized load? | Qlik Community</A></P><P></P><P>HTH</P><P></P><P>André Gomes</P></BODY></HTML> Mon, 05 Sep 2016 10:35:07 GMT https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144462#M374650 agomes1971 2016-09-05T10:35:07Z Re: Filter Data while loading https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144463#M374651 <HTML><HEAD></HEAD><BODY><P>Try like this?</P><P></P><P>Load</P><P>*,</P><P><STRONG>if(State='ORISSA', State) as State</STRONG></P><P></P><P>From YourQVD;</P></BODY></HTML> Mon, 05 Sep 2016 10:57:29 GMT https://community.qlik.com/t5/QlikView/Filter-Data-while-loading/m-p/1144463#M374651 Anonymous 2016-09-05T10:57:29Z