Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
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