Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Expression with date

Dear Friends

I have following Expression which is working well.

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {"$(=Max(TRAN_DATE))"}>} DISTINCT POLICY_NO)

but when I add the part in red   the following expression does not work

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {"$(=Max(TRAN_DATE))"},END_DATE = {"$(=Max(TRAN_DATE)-1, 'DD-MMM-YY')"}>} DISTINCT POLICY_NO)

Pls help me

9 Replies
antoniotiman
Master III
Master III

END_DATE = {"$(=Date(Max(TRAN_DATE)-1, 'DD-MMM-YY'))"}

upaliwije
Creator II
Creator II
Author

Hi Antonio

Still the result is 0

Screenshot_1.png

sunny_talwar

END_DATE is in DD-MMM-YY format?

upaliwije
Creator II
Creator II
Author

Yes Sunny

Screenshot_1.png

sunny_talwar

A single POLICY_NO can have single TRANS_DATE or multiple TRANS_DATE?

upaliwije
Creator II
Creator II
Author

Basically a single TRAN_DATE but sometimes multiple dates can occur

sunny_talwar

In you screenshot above, do you have Date(Max(TRANS_DATE), 'DD-MMM-YYYY') = '15-Aug-2017'?

upaliwije
Creator II
Creator II
Author

Yes Sunny

Screenshot_1.png

Anil_Babu_Samineni

Try to split and check where you are not getting. Like this?

Count({<RENEWED_PREMIUM = {'>0'}>} DISTINCT POLICY_NO)


Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {'$(=Max(TRAN_DATE))'}>} DISTINCT POLICY_NO)

......

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful