topic Re: WHAT IF with Input Field in QlikView

WHAT IF with Input Field

Fri, 26 Sep 2014 18:05:52 GMT

Hello Guys i have a little question, i´ve seen that a lot of people uses WHAT IF analysis setting variables, what i havent seen people using what if with input fields. Why ?

thank you all

cheers

Re: WHAT IF with Input Field

Fri, 26 Sep 2014 18:39:36 GMT

Hi Jeremias For example A+B=C and C you have taken input from the user, so the value of A and B will be changed accordingly. 1. If user enters value of C = 30 and A value is fix to 10 so 20 will be assigned to B 2. if user enters value of C = 25 and A value is fix to 10 so 15 will be assigned to B Hope this helps MV

Re: WHAT IF with Input Field

fkeuroglian — Fri, 26 Sep 2014 23:31:00 GMT

Hi, you can use and create what if use a slider or input field, the differences is that using slider you controle the value that will set the user, but if you create an imput field you never control this value, the user can insert any value and data(posible could be a text)

both of them are equal and have the same objective, but using slider you have more control in what the user set

good luck

Fernando

Re: WHAT IF with Input Field

Mon, 29 Sep 2014 12:33:20 GMT

Ok Fernando, thank you.

I see that you are answering all my questions about Input Fields, Ok, i made this question because i haven´t seen examples or demos of WHAT IF with input fields, do you have any? But i understaund the point, is the same.

Re: Re: WHAT IF with Input Field

fkeuroglian — Mon, 29 Sep 2014 12:36:08 GMT

Hi Jeremias, see this hope helps

Fernando

Re: Re: WHAT IF with Input Field

Mon, 29 Sep 2014 14:04:25 GMT

Thank you, this is very useful!!

Now i'm creating a little example of what if with a load inline table, but i´m getting in trouble. Im think i'll create another question haha.

Re: WHAT IF with Input Field

fkeuroglian — Mon, 29 Sep 2014 16:48:28 GMT

Jeremias no problem, put another question and i respond without problem

Re: WHAT IF with Input Field

Mon, 29 Sep 2014 17:47:04 GMT

Thanks! I Made an what if with a variable, and i made a what if with input field.

What i did is this.

Replace the var with a field in the expressions, and put an input field to change the value of the field.

Re: WHAT IF with Input Field

fkeuroglian — Mon, 29 Sep 2014 17:50:11 GMT

Perfect, Jeremias, and it works

the problem is if the user put text? or a big number ? how do you controle

Re: WHAT IF with Input Field

Mon, 29 Sep 2014 18:13:53 GMT

I guess that there is no solucion for that. Am i right ?

Re: WHAT IF with Input Field

fkeuroglian — Mon, 29 Sep 2014 18:15:17 GMT

Yes, there is no solution for these recommend use slider in the what if

Re: WHAT IF with Input Field

Mon, 29 Sep 2014 18:22:41 GMT

Thank you, i think the input field is a very limitated function.