not changing value in text box after choose any date field

[shamiul_islam]

Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed the value in the text box but that's not working. When I choose date or month from the field the average value is changed but I don't want any effect for the average value in the text box. I use a set analysis in the equation. Here is the equation:

=num((Sum({<Month-=,Mday-=,Month-={"$(=vCurrentMonth)"},Year={"$(=vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month-=,Mday-=>} Month)-1))/1000000,'###0.0')

where, vCurrentMonth=2019

Please help me ASAP, Thanks.

[treysmithdev · Accepted solution]

This should work if vCurrentMonth and vCurrentYear are static values. 

=num((Sum({<Date=,Mday=,Month={"<$(vCurrentMonth)"},Year={"$(vCurrentYear)"}>}Gross_Value)/
(count(distinct {<Month=,Mday=,Date=>} Month)-1))/1000000,'###0.0')

If vCurrentMonth and vCurrentYear are expressions then you will need to adjust them to so they ignore selections.

[shamiul_islam]

Thanks that's working