Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Text object with Fortnight Figures

Hi,

Please see attached. I need to create two expressions with reference to the latest date:

1. Sum of Sales for the current fortnight; and

2. Sum of Sales for the previous fortnight

The fortnight figures should change automatically with reference to the latest date. Any ideas how I can achieve the result?

Thanks

2 Replies
simon_minifie
Partner - Creator III
Partner - Creator III

Hi Shamit,

Try the following:

Sales for last 14 days:

=Sum({<Date={">=$(=Max(Date)-14)"}>}Sales)

Sales for previous 14 days:

=Sum({<Date={">=$(=Max(Date)-28) <=$(=Max(Date)-14)"}>}Sales)

Thanks,

Simon

shamitshah
Partner - Creator
Partner - Creator
Author

Hi Simon,

I don't think the above works . I need the figures for the fortnight periods as in the list box.

Your formula gives me the sales for the last 14 days based on the latest date.

Thanks