Qlikview graph

[tunoi]

Hi Guys,

I have the following table:

Year	Value
2000	100
2001	200
2002	150
2003	300
2004	450
2005	200
2006	130
2007	320
2008	300
2009	290
2010	150
2011	160
2012	170
2013	300
2014	400
2015	200
2016	170
2017	300

The user want to select one year: let say that the user will select 2017

I've been asked to to the following 2 analysis:

1. Straight table

year	Expresion1	Expresion2
2013	300	630
2014	400	870
2015	200	900
2016	170	770
2017	300	670

This should display the last 5 year(based on user selection so in this case 2013-2017). The expresion definition are:

     - expression 1 = sum(value)

     - expression 2 = sum(value where year >= year -3 (last 3 years starting from year from dimension) EX: for 2017 i should display sum of values from 2015-2017, for 2013 sum of values from 2011-2013 etc

I've tried using rangesum but i didnt have any success.

2. Column Bar:

Here on the axes X to display only the year selected as label but on the column part to have all the year.

Anyone can point me to the right direction?

Regards,

Ionut

[tresesco]

Like this?

[tunoi]

yes, ty for that.

Do you happens to know some way to do the seconds request to?

[tresesco · Accepted solution]

This?

[tunoi]

Perfect.

ty