Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

INPUTFIELD on server

Hi:

I am wondering how data for INPUTFIELD works between opening on Access Point and opening on local machine using Qlikview Desktop.

I have tried by creating a dashboard with an inputfield.

What I have found is that the data I changed when using Qlikview Desktop cannot be viewed when using Access Point. And when I change data on Access Point, I cannot see the changes using Qlikview Desktop.

Is it possible to let any changes in data can be viewed on both ends?

Thank you very much.

PC

Tags (1)
1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

Re: INPUTFIELD on server

Hi,

If what you want is to provide every user of that document with all the values prior users have put into that Input_box, you have to provide them with a button to trigger a partial_reload that will store that value (alongside all those which were input earlier) in a small table and store it as a qvd - and the next user needs a button to trigger another type of reload that will load just this qvd and create a listbox from which he can choose - or input a new value.

Quite a complicated task as I am not sure all of that is possible with Document_CALs. i tried to build something similar a few times, but ultimately failed.

Maybe - but I have no experience there - notes on the objects would be a possibility, but I have an inkling those are not possible on AP, only using the Desktop_version.

5 Replies
andrespa
Valued Contributor

Re: INPUTFIELD on server

Hi Baikang, I think what happens is that the data you put into the inputfields -no matter desktop or server- will be lost after you close your dashboard.

Hope it helps.

Andrés

datanibbler
Esteemed Contributor

Re: INPUTFIELD on server

Hi,

what do you want to do with the Input_field? usually, it is used to get some input from the user which is then used in calculations - it is stored merely as a temporary variable, just like Andres proposed. It is not saved as part of the qvw.

When you want users (via Access_Point) to use the variables ?you? put in on Desktop, you have to use a routine to write those to a little table and make it a listbox from where your users can select.

Best regards,

DataNibbler

Re: INPUTFIELD on server

In QV Desktop, InputField data is kept in the document itself. IMHO in the AP, between sessions the InputField values are stored in the Shared file. In your Desktop environment, there is no Shared file, and in the server environment, you as a user cannot change the QVW file.

datanibbler
Esteemed Contributor

Re: INPUTFIELD on server

Hi,

If what you want is to provide every user of that document with all the values prior users have put into that Input_box, you have to provide them with a button to trigger a partial_reload that will store that value (alongside all those which were input earlier) in a small table and store it as a qvd - and the next user needs a button to trigger another type of reload that will load just this qvd and create a listbox from which he can choose - or input a new value.

Quite a complicated task as I am not sure all of that is possible with Document_CALs. i tried to build something similar a few times, but ultimately failed.

Maybe - but I have no experience there - notes on the objects would be a possibility, but I have an inkling those are not possible on AP, only using the Desktop_version.

jafari_ervin
Contributor III

Re: INPUTFIELD on server

end user should right click on the input column in the table then select  RestoreValue ->Restore All Value;


if you comment or not execute the input field command in your script then all your value reset, then for this purpose please set the if statement for your input field like below then create two job in qlikview server depend on another. first with passing 1 and second with passing 0 (in Reload Tab -> Passing Parameter);


if('$(v_ReloadType)'=1) then  

INPUTFIELD inputfield1;

end if;

Community Browser