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: 
Not applicable

Expression Question

Hi - I'm relatively new to qlik sense and have a quick question which I hope provides a straight forward answer. I'm using this as an office solution and we have contract IT help that has built the back end for me. In my dashboard, I'm using the below expressions to calculate my actual expenditures in a period. How can I manipulate these expressions though to incorporate "current month" and "year to date" instead of having to manually adjust the months in the formula? See screenshot below.

2017-03-09_9-38-24.jpg

1 Reply
petter
Partner - Champion III
Partner - Champion III

You should be able to do something like this:

Sum( {$<[Version] = {'Actual'}, [Month] = {"$(=Capitalize(Date(Today(),'MMM')))"} AMOUNT)