Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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