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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
SwathiSingh
Contributor II
Contributor II

Select possible range

Hi,

I am looking for some suggestions on how to make this work. I have a field 'Fiscal period' (July thru Jan Months). If a user selects Dec from fiscal period, I want the 'ID' field to show 835 to 840 selections . I gave a try with possible triggers but it selects just one value i.e when I selected Sep in 'Fiscal period' it selected 837 in ID field. But I want it to show the selected range from IDs.

Please take a look and let me know if you have any suggestions. Thanks for your help in advance.

Example:

If I select Dec in Fiscal Period then ID field should select the range from 835 to 840

If I select August in Fiscal Period then ID field should select the range from 835 to 836Selection1.PNGExample1a.PNGExample1b.PNG

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

See https://qlikviewcookbook.com/2016/01/scoping-selections-with-aggr/. The general idea would be to use a calculated dimension like:

=Aggr(only([Fiscal Period]), ID)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

SwathiSingh
Contributor II
Contributor II
Author

Rob,

Sorry for the delayed reply was just caught up with other things. 

Thanks for the solution/links and your help.

Swathi