Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
ugurarslan
Creator
Creator

All unallocated cash receipt till end of last month

Dear all,

In order to see all unallocated cash (to a customer account) I use the following expression:

Sum({<

[code of cash applied]={'unallocated'},

[date of cash applied]={"<=$(=today())"}

>}[cash applied total USD])

Now I want to see what case was unapplied till end of last month. This in order to see the difference between today and end of last month.

What expression do I need to use for the date of cash applied?

Ugur

2 Replies
bwisealiahmad
Partner
Partner

Hi,


Can you try this:

[date of cash applied]={"<=$(=today())>=$(=MonthEnd(AddMonths(Today(),-1)))"}

Best,

Ali A

juraj_misina
Partner
Partner

Hi,

That'd be

Sum({<

[code of cash applied]={'unallocated'},

[date of cash applied]={"<=$(=MonthEnd(AddMonths(today(), -1)))"}

>}[cash applied total USD])

Hope this helps.

Juraj