Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

woshua5550
Contributor III

SELECT VS DIRECT QUERY

Hi , guys

look at this

using SELECT method :

Right1.png

Result:

Right2.png

This is what i want and then i try to trun it into DIRECT QUERY method

using DIRECT QUERY method:

Wrong1.png

the result is as follow

Wrong2.png

How could this possible?

could anyone tell me what's wrong with it?

DATABASE: SAP HANA

thanks in advance