Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Rob,
Sorry for the delayed reply was just caught up with other things.
Thanks for the solution/links and your help.
Swathi