Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
Are you trying to do set analysis?
Then try this...
count({$<CloseType_CA={'0'}, PaidSts_CAD={'0'}, CicilDate_CAD={"$(=Now())"}>} NoRek_CA)
Shumail
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
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
OR if you can share some sample of ur data then I might resolve ur issue.
Shumail
ah i get it, thank you so much shumail,
i will try it
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 )