updating value in input box

[#1]

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

[emteam162]

Hi amuthabharathi,

I have more then 15 variable and i buildet them dynamically

How i can update them automatically

Best Regards,

Emteam

[#3]

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

[emteam162]

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

[#5]

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

[emteam162]

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

[#7]

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

[emteam162]

Hi cristina.pasqualucci

I create a simple application

I hope that help you.

Many thanks

Emteam

[#9]

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

[emteam162 · Accepted solution]

Hi cristina.pasqualucci

sorry I have been on vacation.

See the attachement.

Best Regards,

Emteam

[#11]

Hi Emteam,

it seems to work.

Many thanks

cristina