Is it possible to update a date parameter from the selection of a drop-down control that is tied to a string parameter? For instance, the drop-down selection of 2025-01-01 - 2025-12-31 would be parsed to select values 2025-01-01 and 2025-12-31. These values would then be applied this as the values of two date type parameters.
Hi @auwade and welcome to the Quick Sight community!
So are your string values in the drop-down control a set of default values?
Could you share a screenshot of what your drop down looks like (with at least some of the values)?
Hi Brett,
This is a sample of what I was trying to describe. Ideally, I would like the parameter value attached to the selection from the drop-down control to be parsed and applied to the parameters being used as date controls. So, in this example, selecting 2027-01-01 - 2027-12-31 would be parsed as 2 dates, 2027-01-01 and 2027-12-31. Then the 2 date controls would apply these values.
Hi @auwade,
Thanks for sharing. So the exact functionality of what you’d like to accomplish is not currently possible in QS, but there may be a work around we can utilize.
In terms of available value options in ‘Reporting Period’; I’m guessing you made this parameter using custom values as opposed to linking to a dataset field, correct? How many value options are there going to be for ‘Reporting Period’ and will they change constantly or will the always stay the same?
Additionally, are your ‘encounter start date’ and ‘encounter end date’ parameters using the same date field?
Yes, in this case I made the values custom. These values should always be the same for this control and in this case there are 2 values. The encounter start date and end date are 2 separate parameters at the moment, but they are being used to filter the date range for a single date field in the dataset.
Hi @auwade,
Quick Sight unfortunately does not have a feature that allows you to parse part of a parameter to use as a default for another parameter. In this case though, as there are only 2 custom options, there is a work around you could try out:
Setup two sets of date parameters with defaults that match each of the 2 custom options. Then, setup an ifelse statement that sets the date values based on what your custom parameter selection is.
If you want to show the start and end date parameters as well as the custom value parameter, you can setup rules to ‘show’ and ‘hide’ the date parameters based on the custom parameter.
Let me know if that could work for your case
Yes, that is a probably the closest to the behavior I wanted. Ideally, there would also be an action to reset the parameter value on the hide/show action as well, but this might the best option for now. Thanks for your help!