Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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)
actually i want to implement in expression can u plz help me with that.