Select possible range

[SwathiSingh]

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 836

[rwunderlich · Accepted solution]

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]

Rob,

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

Thanks for the solution/links and your help.

Swathi