topic SQL Query with Qlikview in QlikView

SQL Query with Qlikview

Jacob — Sat, 16 Nov 2024 03:54:20 GMT

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?

Re: SQL Query with Qlikview

jonathandienst — Wed, 10 Apr 2019 06:37:51 GMT

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.

Re: SQL Query with Qlikview

jonathandienst — Wed, 10 Apr 2019 06:44:43 GMT

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)

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)

Re: SQL Query with Qlikview

Jacob — Wed, 10 Apr 2019 06:58:28 GMT

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