Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

How to auto select the possible values in another field?

Hi Qlik,

I've two filters (FiscalYear and YearNumber) for some reason I've to use both in the dashboard and both filter shows the same data. 

If I need to select FiscalYear field values as "2023" then the same selections should happen in the YearNumber filter too. how to achieve this?

Labels (1)
3 Replies
marcus_sommer

I couldn't recommend any kind of auto-selection  else I suggest to place an appropriate reference within all needed expressions. This may look like:

sum({< YearNumber = p(FiscalYear) >} Value)

deepanshuSh
Creator III
Creator III

I am not sure if there is a direct way possible for this. But a work around could be that you create a Go button next to the filter, and set field selections action in the button and select the value from first selection in the second filter. 

 

 

Trial and error is the key to get unexpected results.
MuraliPrasath
Creator III
Creator III
Author

Sure! I'll give it a try and keep you updated. Thanks for your info !!