topic SELECT VS DIRECT QUERY in QlikView https://community.qlik.com/t5/QlikView/SELECT-VS-DIRECT-QUERY/m-p/1035644#M637634 <HTML><HEAD></HEAD><BODY><P>Hi , guys</P><P>look at this</P><P></P><P>using SELECT method :</P><P><IMG alt="Right1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122941_Right1.png" style="width: 620px; height: 94px;" /></P><P></P><P>Result:</P><P><IMG alt="Right2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/122945_Right2.png" style="height: auto;" /></P><P>This is what i want and then i try to trun it into DIRECT QUERY method</P><P></P><P>using DIRECT QUERY method:</P><P><IMG alt="Wrong1.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/122946_Wrong1.png" style="width: 620px; height: 102px;" /></P><P>the result is as follow</P><P><IMG alt="Wrong2.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/122947_Wrong2.png" style="height: auto;" /></P><P>How could this possible?</P><P>could anyone tell me what's wrong with it?</P><P></P><P>DATABASE: SAP HANA</P><P></P><P>thanks in advance</P><TABLE></TABLE></BODY></HTML> Thu, 28 Apr 2016 08:05:32 GMT woshua5550 2016-04-28T08:05:32Z SELECT VS DIRECT QUERY https://community.qlik.com/t5/QlikView/SELECT-VS-DIRECT-QUERY/m-p/1035644#M637634 <HTML><HEAD></HEAD><BODY><P>Hi , guys</P><P>look at this</P><P></P><P>using SELECT method :</P><P><IMG alt="Right1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122941_Right1.png" style="width: 620px; height: 94px;" /></P><P></P><P>Result:</P><P><IMG alt="Right2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/122945_Right2.png" style="height: auto;" /></P><P>This is what i want and then i try to trun it into DIRECT QUERY method</P><P></P><P>using DIRECT QUERY method:</P><P><IMG alt="Wrong1.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/122946_Wrong1.png" style="width: 620px; height: 102px;" /></P><P>the result is as follow</P><P><IMG alt="Wrong2.png" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/122947_Wrong2.png" style="height: auto;" /></P><P>How could this possible?</P><P>could anyone tell me what's wrong with it?</P><P></P><P>DATABASE: SAP HANA</P><P></P><P>thanks in advance</P><TABLE></TABLE></BODY></HTML> Thu, 28 Apr 2016 08:05:32 GMT https://community.qlik.com/t5/QlikView/SELECT-VS-DIRECT-QUERY/m-p/1035644#M637634 woshua5550 2016-04-28T08:05:32Z