topic YTD MTD QTD in QlikView

YTD MTD QTD

prma7799 — Mon, 16 Feb 2015 11:44:47 GMT

Hi All,

I want to do YTD MTD QTD on Order Amount but all values coming same.

Thanks

Prashant

prma7799 — Mon, 16 Feb 2015 12:30:30 GMT

Any help?

Michiel_QV_Fan — Mon, 16 Feb 2015 12:39:21 GMT

If you remove the header names from your expression you will see the result from your formulas. OrderDate is not resolved.

The varable is not resolved ok.

Try this:

=sum({<OrderYear={$(=vMaxYear)},OrderDate={"<=$(=max(OrderDate))"}>} [Ordered Amount])

Mon, 16 Feb 2015 14:01:10 GMT

Have a look This one.

Thanks

prma7799 — Mon, 16 Feb 2015 18:04:35 GMT

Hi Sovan,

Is there another any another way for YTD MTD QTD....

Thanks

Prashant