topic Re: Select possible range in QlikView

Select possible range

SwathiSingh — Sat, 16 Nov 2024 01:02:09 GMT

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

Re: Select possible range

rwunderlich — Tue, 17 Mar 2020 20:32:39 GMT

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

Re: Select possible range

SwathiSingh — Wed, 25 Mar 2020 18:31:36 GMT

Rob,

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

Thanks for the solution/links and your help.

Swathi