MTD ,QTD,YTD in Pivot Table

[poooja]

Hi Friends,

I need a help on finding MTD,QTD,YTD values in Pivot Table. I have written a code for MTD but it is  Currently it showing overall quantity. i need only current month qty (Ex; February month value only)
Also this value should not change when i select the months in the dashboard. But the values are changing when i select a month. Attached is the qvw. Hope someone will help me here..

Thanks!

Pooja

Before selecting any month: 

After selecting the month value: (But here my expectation is pivot table should show only feb value)

[Claudiu_Anghelescu]

Please check Script Editor, variables and the new expression.

[poooja]

Thanks for your response. 

I have  another table which has the field YearMonth. When i select YearMonth this code is not working. Also i need to know how to calculate Day to day,QTD,YTD  on the same table in a separate column.

Please help me here.  I have attached the updated Qlik file.

Thanks!
Pooja