Select in Field Trigger (based on variable)

r_wroblewski — Tue, 11 Nov 2014 04:15:59 GMT

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

topic Select in Field Trigger (based on variable) in QlikView

Select in Field Trigger (based on variable)