Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.