SQL Query with Qlikview

[Jacob]

HI,

I have sql query which i have to implement in Qlikview.

Query

(SELECT MIN(date) 
FROM xyz A1 
WHERE A1.dff=A.nid
P_code IN (58,656,46,49,10) ),'DD-MON-YYYY') NDate

How to write same SQL query in qlikview?

[jonathandienst]

The reference to table A comes from elsewhere in the script from which you cut this snippet. There is no way to implement that without some idea of what A is. In general, you could use this approach

LOAD Date(NDate, 'DD-MMM-YYYY') as NDate;
SQL SELECT MIN(date) as NDate, ...

But make sure that whatever you include in the SQL statement is a valid SQL expression in your DBMS.

[jonathandienst]

If A is a table, then you could use

LOAD Date(NDate, 'DD-MMM-YYYY') as NDate;
SQL SELECT MIN(date) as NDate
FROM xyz A1 
	left join <name of table A> A
WHERE A1.dff=A.nid
P_code IN (58,656,46,49,10)

or

LOAD Date(NDate, 'DD-MMM-YYYY') as NDate;
SQL SELECT MIN(date) as NDate
FROM xyz A1, <name of table A> A
WHERE A1.dff=A.nid
P_code IN (58,656,46,49,10)

[Jacob]

actually i want to implement in expression can u plz help me with that.