Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hello all, what is syntax of GETDATE ?

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

1 Solution

Accepted Solutions
shumailh
Creator III
Creator III

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 Yes

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

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

Shumail

View solution in original post

8 Replies
Not applicable
Author

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.

Not applicable
Author

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
Creator III
Creator III

Are you trying to do set analysis?

Then try this...


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


Shumail

Not applicable
Author

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
Creator III
Creator III

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 Yes

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

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

Shumail

shumailh
Creator III
Creator III

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

Shumail

Not applicable
Author

ah i get it, thank you so much shumail,

i will try it

Not applicable
Author

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 )