topic Re: Limiting Date Range in Chart in QlikView

Limiting Date Range in Chart

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

I have a chart below that compares 2016 and 2017 values. How do I limit the months that are shown, so that those months without comparison (i.e., November and December) are not shown? You can see below that there is not yet 2017 data for November or December, so I don't want to include these until data is populated. Is there a dynamic way to do so? So that when November data pulls in, we can see the previous year's data come back into view?

Re: Limiting Date Range in Chart

Mark_Little — Wed, 22 Nov 2017 13:49:11 GMT

Hi Claire,

You could try using a calculated dimension.

First set up a new variable to hold current year

vCurrentYear = YEAR(TODAY())

Your calculated dimension.

=IF(SUM({<Year={$(vCurrentYear)>}}VALUE) <> 0, Month).

Mark