topic Re: MTD Value in QlikView

MTD Value

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 10 Apr 2017 13:45:21 GMT

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

mhmmd_srf — Mon, 10 Apr 2017 13:51:11 GMT

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 — Mon, 10 Apr 2017 13:53:10 GMT

May be this

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

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

sunny_talwar — Mon, 10 Apr 2017 13:55:50 GMT

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

mhmmd_srf — Mon, 10 Apr 2017 14:07:02 GMT

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 — Mon, 10 Apr 2017 14:09:14 GMT

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

Best,

Sunny