topic Re: Current Year on chart in QlikView

Current Year on chart

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

I want a chart to automatically show this years data, regardless of the selection and can't figure it out at all. What is the best way to do this?

sunny_talwar — Thu, 08 Sep 2016 15:34:57 GMT

May be use an expression like this:

Sum({<Year = {"$(=Year(Today())"}>}Sales)

khaycock — Thu, 08 Sep 2016 15:46:53 GMT

The initial expression was Count(NCM_ID).

When I put the two together like Count({<Year = {"$(=Year(Today())"}>}NCM_ID) it doesnt work

sunny_talwar — Thu, 08 Sep 2016 16:38:49 GMT

Do you have a Year field in your application? Can you share more information of what you have?

Anonymous — Thu, 08 Sep 2016 16:47:33 GMT

Just adding to Sunny T response.

Count({1<Year = {"$(=Year(Today())"}>}NCM_ID)

It should work if you have a 'Year' field in your database.

khaycock — Fri, 09 Sep 2016 07:58:50 GMT

It's just come up with Allocated memory exceeded now

sunny_talwar — Fri, 09 Sep 2016 15:29:28 GMT

Would you be able to share a sample?

khaycock — Mon, 12 Sep 2016 07:42:28 GMT

This is the graph but with the allocated memory exceeded. Not sure what else I can do about it really?

sunny_talwar — Mon, 12 Sep 2016 15:30:41 GMT

I think one of the parenthesis was missing

Count({1<Year = {"$(=Year(Today()))"}>}NCM_ID)

khaycock — Tue, 13 Sep 2016 08:06:02 GMT

It now doesn't change at all when any other selections are made, is that a thing?

sunny_talwar — Tue, 13 Sep 2016 15:41:24 GMT

Then get rid of the 1 from your expression

Count({1<Year = {"$(=Year(Today()))"}>}NCM_ID)

Like this:

Count({$<Year = {"$(=Year(Today()))"}>}NCM_ID)