help with expression

[aaronnayan]

Can someone help me with this

I want to find the sales of desk_table for the current month in qlik

=Money(sum(Month(Today())[desk_table]))

[ahaahaaha]

Hi

Try

Money(sum({<Month={"=Month(Today())"}>}[desk_table]))

[aaronnayan]

sorry andrey thats totalling all the months

if it helps i have made a variable for the current month vCurrent_Month

[sunny_talwar · Accepted solution]

I think you forgot the dollar sign expansion.

Money(sum({<Month={"$(=Month(Today()))"}>}[desk_table]))

and may be you need year as well

Money(sum({<Month={"$(=Month(Today()))"}, Year = {"$(=Year(Today()))"}>}[desk_table]))