topic Re: updating value in input box in QlikView

updating value in input box

Tue, 30 Apr 2013 11:52:41 GMT

Hi experts,

I'm using an input box in the QVW doc. I update the input box value and then close the document from server.

When I open the doc I would like to see the updated value in the input box.

Is it possibile?

Many thanks

best regards

Cristina

Re: updating value in input box

its_anandrjs — Tue, 30 Apr 2013 12:24:46 GMT

Hi,

Yes you get the last input value on the input box see the sample app.

Regards,

Anand

Re: updating value in input box

Tue, 30 Apr 2013 12:29:05 GMT

when in inputbox--> add variable--> add write its value then save doc. then close the qv file.

now when u open the qv file then this automatically saved the last value in input box

Re: updating value in input box

Tue, 30 Apr 2013 12:33:04 GMT

Hi Anand,

thank you for help, but this not work if you put document in a server

Do you have any other idea?

Regards,

cristina

Re: updating value in input box

Tue, 30 Apr 2013 12:35:32 GMT

hi,

thank you.

I konw what you mean, but if users have to updated value when the document is on the server, they can't save any changes.

thanks

Cristina

Re: updating value in input box

Thu, 02 May 2013 09:35:38 GMT

Hi experts,

is it possibile to solve this problem creating a button with a macro?

If yes, how have I to write the macro?

thank you

Re: updating value in input box

emteam162 — Mon, 27 May 2013 22:47:10 GMT

Hi cristina.pasqualucci

I have same problem as you.

Have you found any idea to solved this probleme

Please share with me the solution

Many thanks,

Emteam

Re: updating value in input box

calvindk — Mon, 27 May 2013 23:53:11 GMT

You could probably export the values to excel via macro whenever a change in an inputfield is made, and have the document reload that on open.

Re: updating value in input box

emteam162 — Tue, 28 May 2013 06:14:09 GMT

Hi Anders Møller

Please, can you share a exemple application Qlikview

Best Regards,

Emteam

Re: updating value in input box

Tue, 28 May 2013 06:25:56 GMT

Hi Cristina,

Use any triggers if anychanges made in value then the trigger will automatically update the value

Re: updating value in input box

emteam162 — Tue, 28 May 2013 06:44:21 GMT

Hi amuthabharathi,

I have more then 15 variable and i buildet them dynamically

How i can update them automatically

Best Regards,

Emteam

Re: updating value in input box

Tue, 28 May 2013 09:32:24 GMT

Hi Emteam,

have a look at this discussion:

http://community.qlik.com/thread/51646

maybe it can help you.

Please if you understand how to create the trigger or how to export the value to excel, or if you have other idea, let me konw.

Best Regards

cristina

Re: updating value in input box

emteam162 — Tue, 28 May 2013 10:48:51 GMT

Hi cristina.pasqualucci

Thanks for your Answer its help me

but i have one question

If I reload the application is that I keep the values into the input field or baseline

Many thanks for your help.

For your question you can try this

set AppExcel = CreateObject ("Excel.Application") 'AppExcel definition

AppExcel.Visible = True

set obj = ActiveDocument.GetSheetObject("IB06")

obj.SendToExcel

AppExcel.ActiveSheet.SaveAs "Path"

Let me know if this work for you

Please,don't forget my question

Many thanks

Emteam

Re: updating value in input box

Tue, 28 May 2013 12:44:43 GMT

Hi Emteam,

thank you for your suggestion. It works.

Just 2 questions:

1) I want to save the variable name (not the variable label) in the xls file. Is it possible?

2) How is possibile to save more variable in the xls file?

I don't know if I've understood your question correctly. You want to reload file and you want to maintain values in variable?

please let me konw.

thank you in advance

cristina

Re: updating value in input box

emteam162 — Tue, 28 May 2013 13:04:50 GMT

Hi Cristina,

For first question you can create a inputbox without label name in another Sheet and if you don't want show this inputbox you can hid the Sheet.

Second you can use macro to add liste of variable in inputbox

but i don't know limite of rows if you use SendToExcel

for my question i want relaod my application via QMC and if i change value of variable i wante to maintain them after reload.

Many thanks,

Emteam

Re: updating value in input box

Tue, 28 May 2013 14:00:36 GMT

Hi Emteam,

many thanks for your help.I've tried what you suggested,

but I'm not able with macro, so how can I list variable?

For label I've this case: Var_Gen_I_year as variable and 'Gen' as label of Var_Gen_I_year

I would like to write Var_Gen_I_year and its value in the excel file. Do you have any idea?

For your question I think you can use bookmark to save and recall values.

Many thanks

cristina

Re: updating value in input box

emteam162 — Wed, 29 May 2013 15:07:30 GMT

Hi cristina.pasqualucci

I create a simple application

I hope that help you.

Many thanks

Emteam

Re: updating value in input box

Tue, 04 Jun 2013 13:00:02 GMT

Hi Emteam,

I send you our example.

We have lots of variable/input box. For example we have VGen2013_I_10 and VGen2013_G_10
for January. So both label are ‘Gen’, but they are different variables.

Moreover we have two different input boxes and we want to export them. In your example, if I have well understood, you have only 1 input box with 2 different variables and you export the box.

Furthermore we want to export all input box values.

I hope this can help you to understand my problem.

Please, let us know If you have any idea.

Many thanks

Cristina

Re: updating value in input box

emteam162 — Tue, 11 Jun 2013 12:48:10 GMT

Hi cristina.pasqualucci

sorry I have been on vacation.

See the attachement.

Best Regards,

Emteam

Re: updating value in input box

Tue, 11 Jun 2013 13:52:28 GMT

Hi Emteam,

it seems to work.

Many thanks

cristina