Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selection using an expression in Input box

Hi,

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.

3 Replies
Not applicable
Author

can u send screen shot of this

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Not applicable
Author

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