Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shamitshah
Contributor

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
Contributor III

Re: Text object with Fortnight Figures

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
Contributor

Re: Text object with Fortnight Figures

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