Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shamitshah
Contributor

Expression to get the latest month' sales

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

1 Solution

Accepted Solutions
laddu_927
Valued Contributor

Re: Expression to get the latest month' sales

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

2 Replies
laddu_927
Valued Contributor

Re: Expression to get the latest month' sales

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
Contributor

Re: Expression to get the latest month' sales

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