topic Re: SQL Query In Qlikview in QlikView

SQL Query In Qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

how to to below sql query in qlikview

SELECT * FROM XXXXXXXX

WHERE DATE = (SELECT MAX(DATE) FROM XXXXXXXXXXX WHERE TARGET_AREA = 'ABC')

AND TARGET_AREA = 'XYZ';

Regards,

Nagesh

Re: SQL Query In Qlikview

Anonymous — Tue, 27 Dec 2016 08:47:42 GMT

Hi,

Try this

temp:

load MAX(DATE) as DATE

FROM XXXXXXXXXXX WHERE TARGET_AREA = 'ABC';

let vDataMax=Peek('DATE',0,'temp');

DROP TABLE temp;

LOAD * From XXXXXXXX

WHERE DATE='$(vDataMax)' AND TARGET_AREA = 'XYZ';

Best regards,

Cosmina

Re: SQL Query In Qlikview

Anonymous — Tue, 27 Dec 2016 09:05:08 GMT

Hi,

Use below formatt in Qlikview script level.

Table1:

LOAD *

From [DATABASE TABLE] Where TARGET_AREA='ABC' and TARGET_AREA='XYZ'

Table2:

LOAD

Field1,

Field2,

Max([DateField]) as MAX_DATE

Resident Table Table1 groupby Field1;

Drop Table Table1;

Warm regards,

Venkata Sreekanth

Re: SQL Query In Qlikview

tyagishaila — Tue, 27 Dec 2016 10:15:48 GMT

SELECT * FROM XYZ

WHERE DATE = (SELECT MAX(DATE) FROM ABC WHERE TARGET_AREA = 'ABC')

AND TARGET_AREA = 'XYZ';

//First you have to get Maxdate from table ABC,

MaxDate:

Load

Max(DATE) as MaxDate

From ABC.qvd(qvd)

Where TARGET_AREA = 'ABC';

LET vMaxDate = floor(peek('MaxDate'));

//Now Load complete data(Select * From....)

TAB:

Load *

From XYZ.qvd(qvd)

Where DATE = '$(vMaxDate)' and TARGET_AREA = 'XYZ';

You must check date format of DATE field in table XYZ and variable.