Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Restrict date for last 3 dates

HI  All,

Could some one help me  how to use this  

Date={">=$(=addmonths(Max(TempDate), -2)) <=$(=Max(TempDate))"} to restrict the data for last 3 dates in below expression

expression: 1-(sum({<Flag={Close}>}[exp1])/count({< Flag={Close}>} distinct [exp2]))

Thanks In advance

 

 

2 Replies
Highlighted
Creator II
Creator II

Re: Restrict date for last 3 dates

Hi your formula works, I just use attached file for your reference. The first table called Normal is all data view, and another is just latest 3 months in the date field. Thanks!

Highlighted
Digital Support
Digital Support

Re: Restrict date for last 3 dates

The only additional thing I can add to the thread is a Design Blog post that may be of some help:

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.