How to get consecutively 3 values from selections

[#1]

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 · Accepted solution]

You should be able to use set analysis for this:

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

[#3]

Thank you Sunny

[sunny_talwar]

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

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny