topic Re: How to get consecutively 3 values from selections in QlikView

How to get consecutively 3 values from selections

Mon, 10 Oct 2016 13:10:35 GMT

Hi All,

1) I have a scenario, If I select dynamically one value it should be display like after 3 values.

Ex; If I select dynamically 3, it should be display like 3, 4, 5,6 in bar chart as per bar chart values.

2) List1;

2004, abc

2005, bcd

2006, xyz

List2:

2009, ert

2010,dfg

2011, jkl

If I select 2005 year value, it should be display 2009 value. How it posible.

help me anyone.

Thank you in advance.

Lalitha

sunny_talwar — Mon, 10 Oct 2016 15:27:34 GMT

You should be able to use set analysis for this:

Sum({<Year = {"$(='>=' & Max(Year) & '<=' & (Max(Year) + 2)))"}>}Measure)

Mon, 10 Oct 2016 16:25:38 GMT

Thank you Sunny

sunny_talwar — Mon, 10 Oct 2016 16:32:37 GMT

No problem at all, If you got what you wanted, I would request you to close this thread by marking correct response.

Best,

Sunny