I have a situation where, I need to declare an expression in the input box. By selecting the Input box element there need to be an association in the chart like If I have selected Growth in my Input box then it should show the Growth elements
The expression that I need to write in the input box is as follows
IF($(vTax)>0.2,'Growth',
IF($(vTax)>=-0.2,'Status Quo',
IF($(vTax)<-0.2,'Decline',
IF($(vcalcTax)=0 and $(vCalcTax_Previous),'Potential Opportunity'
))
I have used the same expression in the chart and I tried using the multibox and its working fine, but there is a limitation the thing is that after selecting an element remaining elements are being hidden. To select another element I need to deselect the current element and select a new one.
Input boxes are for inputting a value for a variable. Unless you want the variable to contain the text string of your expression it won't do what you want. Perhaps you should use a Text box instead.
I used a variable previously and defined predefined values, In the listed values I have used an expression as '=concat(Variable)' and the input box get the text that is present in the variable like New York, Washington, New jersey
