plis help..... set analyst date

[#1]

Hellow, i'm newbie in qlikview,

pliss help meee

this is my sql code (look at "WHERE"),

SELECT SUM(coraccountdetail.angsuran)
FROM coraccount
INNER JOIN coraccountdetail ON coraccount.norek = coraccountdetail.norek AND coraccount.nopin = coraccountdetail.nopin
WHERE coraccount.closetype = 0 AND coraccountdetail.paidsts = 0 AND coraccountdetail.cicildate < GETDATE()

this is my qlikview code (in expression)

sum ({<CloseType_CA={0}, PaidSts_CAD={0}, CicilDate_CAD ={"< today()"}>} Angsuran_CAD) <--- this won't work

when i delete the cicildate analyst it work,

sum ({<CloseType_CA={0}, PaidSts_CAD={0>} Angsuran_CAD) <-- this work

but i need to set analyst with cicildate

NOTE,

when i load sql to qlikview,

closetype_CA as coraccount.closetype

paidsts_CAD as coraccountdetail.paidsts

cicildate_CAD as coraccountdetail.cicildate (when i load in qlikview script, date(CicilDate) as CicilDate_CAD)

so,

my cicildate_CAD format is already the same as today() function, which is M/D/YYYY,

and why it doesn't work??

help me plis,

Thank you

God Bless

[#2]

Try like this:

Date = {"<$(=date(today(), 'M/D/YYYY'))"}

Or in your case:

sum ({<CloseType_CA={0}, PaidSts_CAD={0}, CicilDate_CAD ={"<$(=date(today(), 'M/D/YYYY'))"}>} Angsuran_CAD)

I added the date() function to make sure that it's converting it to the same format as your cicildate_CAD date format. It has to be an exact string formatting match for the set expression to work.

The way to deal with dates in set expressions is not intuitive. Note the inner $() evaluation to get the result of the today() function.

Good luck!