MTD Value

[mhmmd_srf]

Hi All,

I have an requirement like:

If I select Year and Month , then my Value will show for that Year-Month.

Year = 2017 Month = March, Value = value for March 2017

Now, if user select Date, then my value will show MTD on that date.

If Date = 12/28/2016, then value would be 12/1/2016 to 12/28/2016.

I have created vMaxDate variable, but that is not working properly.

I am attaching my qvw file. Please check Bar Chart (Units) from Monthly View sheet.

Please help.

Thanks,

Sarif

[sunny_talwar]

So what is wrong, it seems to be working, isn't it?

[mhmmd_srf]

No Sunny.. it is showing value for the selected date only... not working as MTD.

Please check Actual Units in Bar Chart.

Below Detail one is showing on selected date basis. the o/p of both are same. It should not be.

Please help.

Thanks,

Sarif

[aarkay29]

May be this

vStartDate=Date(Monthstart(Max(Date#(DateJoinSales,'YYYYMMDD'))),'YYYYMMDD')

sum({<DateJoinSales = {">=$(=$(vStartDate))<=$(=$(vMaxDate))"}>}UnitsActual)

[sunny_talwar · Accepted solution]

This could be because of another date field selection that you have. DateJoinUnits??? How is this related to DateJoinSales?

[mhmmd_srf]

Yes...

Thanks a lot Sunny...

If I take care both date field in my set expression.. it is working fine..

Thanks a lot for your help..

Thanks,

Sarif

[sunny_talwar]

Awesome... please close the thread by marking correct and helpful responses.

Best,

Sunny