topic Re: Set undefined value to variable in QlikView

Set undefined value to variable

neha_sri — Fri, 09 Jan 2015 09:47:53 GMT

Hi all,

I have multiple variables in my qvw and I want to set a trigger which will set undefined value to all variable on opening the document.

Is there a way out to do so.

Thanks in anticipation.

alexandros17 — Fri, 09 Jan 2015 09:51:59 GMT

Unfortunately you cannot do it unless you specify all the variables and set every one to your specified value.

You can do it in the script.

Hope it helps

PradeepReddy — Fri, 09 Jan 2015 09:59:46 GMT

Hi Neha,

If I understand the requirement in correct manner, U want to set all the varibles to predefined values.

If so, try to use the onopening from Document triggers.

neha_sri — Fri, 09 Jan 2015 10:14:01 GMT

Yes, I want that on open the variable should not have any values. User will input the value, but at present my

variables are holding the last given values.

Fri, 09 Jan 2015 10:43:16 GMT

go to document properties->triggers tab->

do the followings

set value as blank or space

I input vInput value as 10

I closed the document and reopen it then value for vInput is

PradeepReddy — Fri, 09 Jan 2015 10:49:25 GMT

Please see the attached pic for triggers.