Set Analysis not working

[#1]

Hello Everyone,

I have this YTD formula working very well. _YYYY and _MM is calendar.

=sum ( {$<[Year] = {$(#=Only(_YYYY))}, [Month] = {"<=$(#=Only(_MM))"}>} [Rev-Actual])

When I do current month, it doesn't work:

=sum ( {$<[Year] = {$(#=Only(_YYYY))}, [Month] = {"$(#=Only(_MM))"}>} [Rev-Actual])

Can you help?

Thank you very much in advance.

[cupelix-qlik]

Struggling to understand what your trying to get to.

If it's a case of you want a Year to Date figure to appear when someone selects a single Year & single Month. If so then I did have this working based on your formula.

=Sum( {$<Year = {$(#=Only(Year))},Month = {"<=$(#=Only(Month))"}>} Distance)

My Month field is 3 letters, Distance was just the first Integer field I came to. Year is just the 4 digits.

[#3]

Swuehl,

I just found my Month was locked for some reason. I don't know when this Month was locked.

I am keep working on this lock problem.

Thanks,

Zili

[#4]

Hello Everyone,

I just found this app has one bookmark locked the Month and has conflict on Month selection.

Sunny always has very good set analysis solution. swuehl helped me how to solve this problem step by step.

Lee Seagrave's suggestion also very valuable on my question.

Thank you all again. I appreciate your help.