topic Re: Need help for Function YTD in QlikView

Need help for Function YTD

tomhovens — Mon, 11 Apr 2016 13:35:36 GMT

Hello all,

I'm looking for a function to calculate the YTD of amount but:

- Peolpe can make a selection on the month doesn't change the outcome of the function

- People can choose the country does change the outcome of the function

This is the function I have till now

=Sum({$<Month=>}amount)

sunny_talwar — Mon, 11 Apr 2016 13:37:27 GMT

Have you checked out this blog -> YTQ, QTD, MTD and WTD

Gysbert_Wassenaar — Mon, 11 Apr 2016 13:37:52 GMT

Perhaps these blog post help:

Mon, 11 Apr 2016 15:02:16 GMT

Whatever filter you want on sum you can add as you added Month.

eg.

=Sum({$<Month=>,Year=>}amount)

like wise. it will just ignore your selection and show the sum.

Regards,

Lokesh