topic Re: Qvd where clause in QlikView https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121258#M900429 <HTML><HEAD></HEAD><BODY><P>Logically it should be OR rather than AND. Try replacing and with or like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">where MarketID=104 <STRONG>or</STRONG> MarketID = 105 <STRONG>or</STRONG> MarketID = 108</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;">There would be easier ways too.<BR /></SPAN></P></BODY></HTML> Fri, 22 Jul 2016 06:10:28 GMT tresB 2016-07-22T06:10:28Z Qvd where clause https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121256#M900427 <HTML><HEAD></HEAD><BODY><P>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; marketID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; marketDescription</P><P>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aaa</P><P>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; bbb</P><P>3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 103&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ccc</P><P>4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 104&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ddd</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 105&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; eee</P><P>7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 106&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fff</P><P>8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 107&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ggg</P><P>9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 108&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; hhh</P><P></P><P></P><P>i want to load the market id 104 ,105, 108 only</P><P></P><P></P><P>i tried in where clause</P><P></P><P>where MarketID=104 and MarketID = 105 and MarketID = 108</P><P></P><P></P><P>but its not working help me</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121256#M900427 stephenedberkg 2020-11-25T16:16:04Z Re: Qvd where clause https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121257#M900428 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P>where match(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MarketID,'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">04' ,'105', '108')</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">or </SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><SPAN style="font-size: 13.3333px;">where <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">MarketID IN </SPAN>(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">04' ,'105', '108')</SPAN></SPAN></SPAN></P></BODY></HTML> Fri, 22 Jul 2016 06:09:39 GMT https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121257#M900428 arulsettu 2016-07-22T06:09:39Z Re: Qvd where clause https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121258#M900429 <HTML><HEAD></HEAD><BODY><P>Logically it should be OR rather than AND. Try replacing and with or like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">where MarketID=104 <STRONG>or</STRONG> MarketID = 105 <STRONG>or</STRONG> MarketID = 108</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;">There would be easier ways too.<BR /></SPAN></P></BODY></HTML> Fri, 22 Jul 2016 06:10:28 GMT https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121258#M900429 tresB 2016-07-22T06:10:28Z Re: Qvd where clause https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121259#M900430 <HTML><HEAD></HEAD><BODY><P>it shud work</P></BODY></HTML> Fri, 22 Jul 2016 06:12:02 GMT https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121259#M900430 gautik92 2016-07-22T06:12:02Z Re: Qvd where clause https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121260#M900431 <HTML><HEAD></HEAD><BODY><P>Hi Stephen,</P><P></P><P>Both the solutions mentioned below should work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Fri, 22 Jul 2016 06:12:44 GMT https://community.qlik.com/t5/QlikView/Qvd-where-clause/m-p/1121260#M900431 jyothish8807 2016-07-22T06:12:44Z