topic Re: Include the current year in Expression in QlikView

Include the current year in Expression

Wed, 25 Nov 2020 16:16:04 GMT

Good day

I have the following expression:

Sum ({<Year = {'2017'}>} Cant_Vend)

What I need is to change the 2017 for a function that takes me the Current Year for a chart and on a following chart subtract one year and show me the year before.

I know I can use the lists as a filter, but that's how they request it.

Thanks for the reply.

Re: Include the current year in Expression

sunny_talwar — Tue, 27 Jun 2017 18:27:00 GMT

May be this

Current Year

Sum({<Year = {$(=Year(Today()))}>} Cant_Vend)

Previous Year

Sum({<Year = {$(=Year(Today())-1)}>} Cant_Vend)

Re: Include the current year in Expression

andre_mueller — Tue, 27 Jun 2017 18:38:03 GMT

Hi Juan,

for the current year you can use:

Sum ({<Year = {$(=Year(Today()))}>} Cant_Vend)

for the year before:

Sum ({<Year = {$(=Year(Today())-1)}>} Cant_Vend)

then:

Sum ({<Year = {$(=Year(Today())-2)}>} Cant_Vend)

and so on..

If you need a dynamic number of Charts (maybe different number of years), the "Trelllis..." option in the Dimension properties tab is maybe worthy to have a look for you.

Regards

André