Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi QlikView Friends,
Please help me with this strange issue.
i'm running this syntax in qlikview on oracle database, but gives me error.
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >$(LASTRELOADTIME));
Thanks
vishwaranjan
Hi,
Include single quotes for variable names
TableName:
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >'$(LASTRELOADTIME)');
Regards,
jagan.
Check for timestamp issue or Variable value?
Hi,
Is single code required?
>'$(LASTRELOADTIME)');
Regards,
Ajay
Hi,
Include single quotes for variable names
TableName:
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >'$(LASTRELOADTIME)');
Regards,
jagan.
Try this:
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT > '$(LASTRELOADTIME)' );
hi
thanks for response,but i had tried but not get success.
i havve also try according to this
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE TO_DATE(CPUDT ,'DD-MM-YYYY')>'$(LASTRELOADTIME)');
************************************************************************************************
and also try according to this
let LASTRELOADTIME = date(date#(today()-1,'DD-MM-YYYY'),'DD-MM-YYYY');
let date_key = 'to_date(CPUDT,'DD-MM-YYYY')';
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE '$(date_key)' >'$(LASTRELOADTIME)');
Thanks
hi sir
your syntax execute successfully. but not compare both date in
WHERE CPUDT >'$(LASTRELOADTIME)');
here fetch all dates of CPUDT
Thanks
Hi,
Check date format LASTRELOADTIME and CPUDT.
Also use this statement
let LASTRELOADTIME = date(today()-1,'DD-MM-YYYY');
Regards,
Jagan.
Hi,
Check out this
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE CPUDT >date('$(LASTRELOADTIME)'));
or
SQL SELECT * FROM MSEG WHERE MBLNR IN (SELECT MBLNR FROM MKPF WHERE date(CPUDT) >'$(LASTRELOADTIME)');
BR,
-dinu1
hi sir
thanks for your response, i checked that both format are same as DD-MM-YYYY
problem is that, both date (CPUDT and LASTRELOADTIME ) are not match.