topic Re: Year to date function in QlikView

Year to date function

Thu, 29 Nov 2012 12:59:29 GMT

I wish to add a year to date function to one of my expressions, but rather then it running from the current date I would like it to run from July. Is there any way that I am able to do this?

Thanks

Re: Year to date function

Gysbert_Wassenaar — Thu, 29 Nov 2012 13:09:07 GMT

Try something like this to get this years sales upto and including July:

sum({<Year={'$(=year(today())-3)'},Month={'<=7'} >} Sales)

This assumes you have a Year and Month field (and a Sales field)

Re: Year to date function

OmarBenSalem — Thu, 21 Jan 2016 13:45:44 GMT

Hi Gysbert,

the -3 in the expression "year(today())-3)", what is that for?