topic Where Exists clarification - QVD optimized while field is concatenated in App Development https://community.qlik.com/t5/App-Development/Where-Exists-clarification-QVD-optimized-while-field-is/m-p/50773#M3392 <HTML><HEAD></HEAD><BODY><P>Temp:</P><P>load * inline [</P><P>Country_Year_Exists</P><P>USA-2015</P><P>IND-2018];</P><P></P><P>FACT:</P><P>load * inline [</P><P>Country,Year,Sales</P><P>USA,2015,100</P><P>USA,2016,200</P><P>IND,2018,150</P><P>IND,2019,200</P><P>GBP,1991,100]</P><P></P><P></P><P>where Exists(<SPAN style="font-size: 13.3333px;">Country_Year_Exists</SPAN>,<STRONG><EM style="color: #ff6600;">Country&amp;'-'&amp;Year</EM></STRONG>);</P><P></P><P><SPAN style="font-size: 10pt;">Can someone explain if this'll still retain the Optimized QVD load?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><A href="https://community.qlik.com/qlik-users/4003">hic</A>‌ <A href="https://community.qlik.com/qlik-users/2286">rwunderlich</A>‌<BR /></SPAN></P></BODY></HTML> Thu, 03 May 2018 15:33:43 GMT vkish16161 2018-05-03T15:33:43Z Where Exists clarification - QVD optimized while field is concatenated https://community.qlik.com/t5/App-Development/Where-Exists-clarification-QVD-optimized-while-field-is/m-p/50773#M3392 <HTML><HEAD></HEAD><BODY><P>Temp:</P><P>load * inline [</P><P>Country_Year_Exists</P><P>USA-2015</P><P>IND-2018];</P><P></P><P>FACT:</P><P>load * inline [</P><P>Country,Year,Sales</P><P>USA,2015,100</P><P>USA,2016,200</P><P>IND,2018,150</P><P>IND,2019,200</P><P>GBP,1991,100]</P><P></P><P></P><P>where Exists(<SPAN style="font-size: 13.3333px;">Country_Year_Exists</SPAN>,<STRONG><EM style="color: #ff6600;">Country&amp;'-'&amp;Year</EM></STRONG>);</P><P></P><P><SPAN style="font-size: 10pt;">Can someone explain if this'll still retain the Optimized QVD load?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><A href="https://community.qlik.com/qlik-users/4003">hic</A>‌ <A href="https://community.qlik.com/qlik-users/2286">rwunderlich</A>‌<BR /></SPAN></P></BODY></HTML> Thu, 03 May 2018 15:33:43 GMT https://community.qlik.com/t5/App-Development/Where-Exists-clarification-QVD-optimized-while-field-is/m-p/50773#M3392 vkish16161 2018-05-03T15:33:43Z Re: Where Exists clarification - QVD optimized while field is concatenated https://community.qlik.com/t5/App-Development/Where-Exists-clarification-QVD-optimized-while-field-is/m-p/50774#M3393 <HTML><HEAD></HEAD><BODY><P>Only with a single parameter will a where exists(FIELD) keep a qvd-load optimized and everything else will force a processing of the data and therefore an unoptimized load.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 03 May 2018 15:38:57 GMT https://community.qlik.com/t5/App-Development/Where-Exists-clarification-QVD-optimized-while-field-is/m-p/50774#M3393 marcus_sommer 2018-05-03T15:38:57Z