Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Year to date function

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

Tags (2)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Year to date function

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)


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Year to date function

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)


talk is cheap, supply exceeds demand
Partner
Partner

Re: Year to date function

Hi Gysbert,

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