Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Previous month Sales calculation

Hi All,

I have a doubt in set analysis for calculating sum of previous month sales. The calculation is based on 5 columns

The expression i wrote in calculation is:

SET Shared.Calculation.SOHValueMonth='SUM({<[FISCAL YEAR]={$1},[FISCAL MONTH]={$2}>} +-++)';

and calling this calculation in expression as:

=NUM($(Shared.Calculation.SOHValueMonth($(=[FISCAL YEAR]),$(Shared.Calculation.CurrentFiscalMonth)-1)), Shared.Format.MoneyRound)

Please let me know if my approach is right.... Thanks in advance.