topic Re: Variable in QlikView

Re: Variable

Fri, 09 May 2014 11:40:16 GMT

Hi all,

I need to define a variable with two values as 'Yes' or 'No', since i need to use this variable in expressions for eg: If (MyVar='Yes',Salary*10,Salary).

how can it be done.

Thanks in advance.

BRegards,

Reena

Re: Variable

anbu1984 — Fri, 09 May 2014 11:43:09 GMT

why do you need to set two values?

Re: Variable

Gysbert_Wassenaar — Fri, 09 May 2014 11:47:46 GMT

Create an InputBox for your variable. On the Constraints tab select Predefined Values in Drop-Down. Enable the option Listed Values in the section Predefined Values. Enter Yes;No in the input field below the Listed Values check box.

Re: Variable

Fri, 09 May 2014 11:49:03 GMT

hi,

Actualy My application is for calculating the salary and bonus for employees.

so in order to calculate one bonus element,i require two values in input Box.

As per the requirement, it should be a drop down with two values either Yes or no, if the user select 'Yes' for that particular employee the salary will be multiplied with 10%.like that.

Thanks

Re: Variable

Fri, 09 May 2014 11:51:36 GMT

Hi,

Thank You..it works,..

Re: Variable

m_woolf — Fri, 03 Apr 2015 18:10:38 GMT

Gysbert,

Do you know if there is any way to set the "Predefined Values in Drop-Down" in a macro?