topic Re: Selection using an expression in Input box in QlikView

Selection using an expression in Input box

Tue, 11 Nov 2014 14:03:15 GMT

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.

Re: Selection using an expression in Input box

Tue, 11 Nov 2014 14:07:26 GMT

can u send screen shot of this

Re: Selection using an expression in Input box

Gysbert_Wassenaar — Tue, 11 Nov 2014 14:28:02 GMT

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.

Re: Selection using an expression in Input box

Tue, 11 Nov 2014 14:57:44 GMT

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