Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
r_wroblewski
Partner - Creator III
Partner - Creator III

Select in Field Trigger (based on variable)

Hello Community

I try to create a formula for a "Select in field" Trigger but it will not work.

Current situation:

Sheet with a google chart & a straight table.

The straight table show results ("$(vFormula1)", "$(vFormula2)" and "$(vFormula1)/$(vFormula2)") for different states.

GoogleMaps should only show "$(vFormula1)/$(vFormula2)".


To enable GoogleMaps to show the correct value, I need to active select the states, which have a value for $(vFormula1)/$(vFormula2).


First of all I want to create a button to select the relevant states.

Does someone has an idea how to create such a trigger which will select all states which have a value for $(vFormula1)/$(vFormula2)?


PS: If all states have a value the map show the correct results but as soon states have no result for $(vFormula1)/$(vFormula2) shows wrong results as long as I not select actively the states with a value.



Best regards,

Ronny

0 Replies