Hello all, what is syntax of GETDATE ?

[#1]

Hello qlikviewers, i'm a newbie in qlikview, plis help me.

i want to get total count of "NoRek_CA(this is my flield)" where Closetype_ca = 0 and paidSts_cad = 0 and cicildate < GETDATE

i type a syntax below,

count ({<CloseType_CA={0}, PaidSts_CAD={0}, CicilDate_CAD={"< GETDATE()"}>}NoRek_CA)

the closetype and paidsts can run, but cicildate eror,

what is the syntax of getdate??

plis help me,

thanks before,

God bless

[#2]

You can use date and time function Today() to get date when the document was last reloaded.

Alternatively you can you Now() function to get system date.

Rgs

Zubair.

[#3]

hello zubairuddin

thx for your reply,

but what is the syntax ?

i type,

count ({<CloseType_CA={0}, PaidSts_CAD={0}, CicilDate_CAD={"< now()"}>}NoRek_CA)

and it can't run, wrong syntax maybe

[shumailh]

Are you trying to do set analysis?

Then try this...

count({$<CloseType_CA={'0'}, PaidSts_CAD={'0'}, CicilDate_CAD={"$(=Now())"}>} NoRek_CA)

Shumail

[#5]

hello shumail, thank you for your reply, i'm appreciate 😄

but it's stil won't work

this is my sql code,

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()

can u help me?

note

in qlikview,,

closetype_CA as coraccount.closetype

paidsts_CAD as coraccountdetail.paidsts

cicildate_cad as coraccountdetail.cicildate

[shumailh · Accepted solution]

Most of the time it would be the issue of date format.. date in now function is in this format "DD-MMM-YYYY HH:MM:SS" you can change the format by Date() function. Check date format in coraccountdetail.cicildate field.

Also check the format for other fields.. and follow the below links I hope you can find your solution thier.. best of luck

http://community.qlik.com/forums/t/18727.aspx

http://community.qlik.com/Search/search.aspx?q=set+analysis+date

Shumail

[shumailh]

OR if you can share some sample of ur data then I might resolve ur issue.

Shumail

[#8]

ah i get it, thank you so much shumail,

i will try it

[#9]

OOOOOHHHHH yeah!

Thanks a lot for this discussion. Now my set is fine! An example for all who need to filter records with today() excluding all selections:

=count({1<[data_creazione]={"$(=today())"},[project_name]={"Help Desk"}>} DISTINCT id )