Expression to get the latest month' sales

[shamitshah]

I have the following expression in QlikView which gives me the right result, but in Qlik Sense it shows a cumulative figure:

=SUM({$<FYKPIFiscalYear = {$(=Max(FYKPIFiscalYear))}, FYKPIMonth= , FYKPIMonthYear={'>=$(vMaxBYM)'}>}Sales)

Any idea what the correct expression should be in Qlik Sense?

Thanks

[Anonymous · Accepted solution]

Shamit, the execution engine of qlikview and qliksense are same. Think there might be something we are missing here.

try this solution. Set Expression Working in QlikView, But Not in Qlik Sense

[shamitshah]

Thanks for pointing it out. I had missed out the variable.