SQL Query In Qlikview

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[tyagishaila]

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.