Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

stephenedberkg
Contributor II

MTD Calculation

how to calculate the MTD values .If i select the January mean it show the January sales values after that i select the FEB mean it show the FEB sales Values only BUT i want the addition of all previous month sales value  .

Eg:

I select the May month sales mean I want Jan,Feb,March,April And May Months sales Vales.

1 Solution

Accepted Solutions

Re: MTD Calculation

Hi,

In your expression try this expression

=Sum({$<Month = {'>$(=Min(Month))) <=$(=Max(Month))'}, Year = {'$(=Max(Year))'}>}  Metrics )

Regards

Anand

View solution in original post

2 Replies

Re: MTD Calculation

Hi,

In your expression try this expression

=Sum({$<Month = {'>$(=Min(Month))) <=$(=Max(Month))'}, Year = {'$(=Max(Year))'}>}  Metrics )

Regards

Anand

View solution in original post

stephenedberkg
Contributor II

Re: MTD Calculation

Thank you for reply Anand Chouhan