topic Re: Restrict date for last 3 dates in QlikView

Restrict date for last 3 dates

priya945 — Sat, 16 Nov 2024 19:16:23 GMT

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

Re: Restrict date for last 3 dates

alex00321 — Tue, 21 Jan 2020 07:51:54 GMT

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!

Re: Restrict date for last 3 dates

Brett_Bleess — Tue, 18 Feb 2020 16:17:31 GMT

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