Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted
Master
Master

Hi

Try

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

Highlighted
Creator III
Creator III

sorry andrey thats totalling all the months

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

Highlighted

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