Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get consecutively 3 values from selections

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








  


   

1 Solution

Accepted Solutions
sunny_talwar

You should be able to use set analysis for this:

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

View solution in original post

3 Replies
sunny_talwar

You should be able to use set analysis for this:

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

Not applicable
Author

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