topic Re: Variable input in QlikView

Variable input

pedwards — Thu, 15 Nov 2018 05:01:43 GMT

Hi Guys

With the new variable input extension, is there a way to save the input that somebody inputs on the sheet for the specific variable. So when you close and open the app again the value of that variable is the last inputted value.

At the moment it changes back to the default value

Re: Variable input

shiveshsingh — Thu, 15 Nov 2018 06:14:36 GMT

Do you want to set the value of variable?

what do you mean by this - "At the moment it changes back to the default value"?

Re: Variable input

pedwards — Thu, 15 Nov 2018 06:21:03 GMT

Yes, I want to set the value. So when I create the variable I set the default value at say 1. I want that value to dynamical change so that when I close and reopen the app the latest inputted value is now the default value.

Apologies if I am using the wrong terminology

Re: Variable input

shiveshsingh — Thu, 15 Nov 2018 06:56:02 GMT

Yes, you can do this.

Go to variable overview and create a variable with default value 1.

Now create an input box wherein you can again set the value for that variable and then that value will be the default value.

Re: Variable input

pedwards — Thu, 15 Nov 2018 07:01:58 GMT

But when I close the app and reopen it the value switches back to 1. Perhaps I am doing something wrong?

Re: Variable input

shiveshsingh — Thu, 15 Nov 2018 07:09:57 GMT

You defined one variable through variable overview, not in script.

It's value is 1.

Now through input box , you defined the value to '2'.

Now you close the application after saving and open it, value will be 2 only.

Re: Variable input

pedwards — Thu, 15 Nov 2018 07:16:56 GMT

Yes, I did exactly that but it changes back to 1. It doesn't even give an option to save if I only change the value in the inputbox

Re: Variable input

shiveshsingh — Thu, 15 Nov 2018 07:21:23 GMT

Ahh, after putting value in input box, press enter. create on text box which shows the value of variable, when you will change value through input box and press enter, value in text box will also change.

Re: Variable input

pedwards — Thu, 15 Nov 2018 07:27:29 GMT

yeah it changes but still goes back to original value after reopening

Re: Variable input

shiveshsingh — Thu, 15 Nov 2018 07:32:10 GMT

Once the value changes, you need to save the application.

Re: Variable input

pedwards — Thu, 15 Nov 2018 07:37:05 GMT

There is no option to save unfortunately

Re: Variable input

shiveshsingh — Thu, 15 Nov 2018 07:56:55 GMT

May be Ctrl +S can help

Re: Variable input

pedwards — Fri, 16 Nov 2018 04:37:23 GMT

I think you are talking about QlikView. I am trying to this in QlikSense. Sorry, I should have specified that at the start.

Re: Variable input

shiveshsingh — Fri, 16 Nov 2018 06:30:19 GMT

Qliksense doesn't have input box functionality, you need to use extension for that.

I didn't try your requirement in sense but in View. 🙂

Re: Variable input

pedwards — Fri, 16 Nov 2018 06:42:20 GMT

yeah Sense released supported extensions in the new version with input functionality ,that is why I wondered if I could do that now. But thanks for your help!