Data by current month in a pie chart

[surtex]

Hey Qlik Member,

i would like to show the values with the following restrictions:

Budget Year = 2022

Month = current Month

Budgettype = A,I,K,R,M

I have a expression that works, but I always have to enter the current month manually :

=Sum({<Budget_Year = {'Plan 2022'}, MonthNbr = {'8'}, Budgettype = {R,M}>} Year_Value_1)

What is the reason for the following expression that its doesn't work???

=Sum({<Budget_Year = {'Plan 2022'}, Month = {'Month(today())'}, Budgettype = {R,M}>} Year_Value_1)

Anybody have an idea???

Thank you.

Regards

Josh

[justISO · Accepted solution]

Hi, try this:

Sum({<Budget_Year = {'Plan 2022'}, MonthNbr = {$(#= num(Month(today())) )}, Budgettype = {R,M}>} Year_Value_1)

[sidhiq91]

@surtex  Please use the below expression in your Set Analysis:

Sum({<Budget_Year = {'Plan 2022'}, Month = {"$(=Num(Month(Today())))"}, Budgettype = {R,M}>} Year_Value_1)

This should resolve your issue.