Qlik Community

Qlik Sense App Development

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

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.


1 Reply

Re: Expression Question

You should be able to do something like this:

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