Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

get value from input box

Hi! I'm newbie starting with qilkview.

I have any question that I wanna get value from input box to a variable

, and then I  wanna save value from the variable to qvd file.

Please expain step by step.

1 Solution

Accepted Solutions
surnar84tcs
New Contributor III

Re: get value from input box

Hi,

1. First create one Input box in the chart this will show a new variable button in the Input Box Properties.

2. Create a name of the Variable and give the values in input box this will assign a value to the variable created using input box.

3. Finally in scripting part create one inline table as below and store the table as qvd. This will solve your purpose.

But this needs to reload every time you changing the variable value

Let vN=$(vNum);

A:

LOAD * INLINE [

Num,A

$(vN),1

];

Store A into ABC.qvd;

Please find the sample application for your reference.

2 Replies
surnar84tcs
New Contributor III

Re: get value from input box

Hi,

1. First create one Input box in the chart this will show a new variable button in the Input Box Properties.

2. Create a name of the Variable and give the values in input box this will assign a value to the variable created using input box.

3. Finally in scripting part create one inline table as below and store the table as qvd. This will solve your purpose.

But this needs to reload every time you changing the variable value

Let vN=$(vNum);

A:

LOAD * INLINE [

Num,A

$(vN),1

];

Store A into ABC.qvd;

Please find the sample application for your reference.

Not applicable

get value from input box

thank you for your help, I try to do that you told it's work.

thank you very much.

Community Browser