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: 
aaronnayan
Creator III
Creator III

help with expression

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]))

1 Solution

Accepted Solutions
sunny_talwar

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]))

View solution in original post

3 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi

Try

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

aaronnayan
Creator III
Creator III
Author

sorry andrey thats totalling all the months

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

sunny_talwar

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]))