Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You should be able to do something like this:
Sum( {$<[Version] = {'Actual'}, [Month] = {"$(=Capitalize(Date(Today(),'MMM')))"} AMOUNT)