Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
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
MVP
MVP

Re: Expression Question

You should be able to do something like this:

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