Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jchambers123
New Contributor II

Limiting data displayed in chart by date

Hello community members,

I have a line chart in which I'm trying to display totals year-by-year, for each of the previous 4 years based on the year selected by the user. For example, if the user selects Y 2017, I'd like it to display totals for Y 2017, Y 2016, Y 2015, and Y 2014 separately. (And if the user selected Y 2013, then it would display the totals for Y 2013, Y2012, Y 2011, and Y2010 separately).

I have some experience with set analysis (which I've used in other contexts but am by no means proficient with yet) and am imagining the solution somehow involves it. In my chart expression, I used the set calculation below and it gives me the total for only 1 year (e.g., it returns the total for Y 2013 when Y 2017 is selected). But that is not exactly what I need -- I need totals for each of the 4 years prior to the selected year to be displayed.

=sum({$<Quarter=,Year={'$(=Max(Year)-4)'}>}Responses)

Any ideas would be appreciated.

Thanks in advance,

-John

1 Solution

Accepted Solutions
krishna_2644
Valued Contributor III

Re: Limiting data displayed in chart by date

2 Replies
krishna_2644
Valued Contributor III

Re: Limiting data displayed in chart by date

jchambers123
New Contributor II

Re: Limiting data displayed in chart by date

Thanks so much, Krishna. It worked beautifully. Also, do you have any idea how I might calculate totals by year, so that, within the same chart, I could get % of total? In other words, % of total for each of the 4 years displayed?