Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
tunoi
Creator
Creator

Qlikview graph

Hi Guys,

I have the following table:

 

YearValue
2000100
2001200
2002150
2003300
2004450
2005200
2006130
2007320
2008300
2009290
2010150
2011160
2012170
2013300
2014400
2015200
2016170
2017300

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

  

yearExpresion1Expresion2
2013300630
2014400870
2015200900
2016170770
2017300670

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:

Capture1.PNG

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

4 Replies
tresesco
MVP
MVP

Like this?

Capture.PNG

tunoi
Creator
Creator
Author

yes, ty for that.

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

tresesco
MVP
MVP

This?

Capture.PNG

tunoi
Creator
Creator
Author

Perfect.

ty