Expression for YTD sales in Qlik sense

[Anonymous]

Hi,

Can somebody help me with a set analysis expression for YTD sales in Qlik Sense.. If I select month march it should be sum of Jan, Feb and March.

I am using this expression  =sum({$ < Version = {"Actual 2016"},Month = {">= {'1'} <=$(=max(Month))"}>}SumOfBudget_Amount)

if I am not selecting anything it is giving YTD .. if I am selecting March it is giving only March month amount not the accumulated ones..

Can somebody advise please.. This is for a qlik sense app..

Thanks

Chandra

[sunny_talwar]

May be this:

=Sum({$<Version = {"Actual 2016"}, Month = {">=1<=$(=Max(Month))"}>} SumOfBudget_Amount)

Where I am assuming that Month is 1,2,3,4,5 and NOT Jan, Feb, Mar, Apr, May

[Anonymous]

Hi Sunny,

Yeah month is 1,2,3,4 etc I have tested the above expression it is still doing the same thing i.e it is showing the selected month's amount not accumulating . to accumulate I need to select all the months. I don't know may the expression works in Qlik view but it is not doing the same in Qlik sense..

Thanks for the response..

Regards

Chandra