topic AW:Re: AW:Refresh inputfields from SQL Server in QlikView

Refresh inputfields from SQL Server

Fri, 18 Jun 2010 07:43:04 GMT

Hello.

I load data from MS SQL Server into several tables. One of the field I load is an inputfield.

Is there any way to refresh the field from SQL after I change the value in inputfield?

AW:Refresh inputfields from SQL Server

biester — Fri, 18 Jun 2010 08:48:36 GMT

Why would you want to do that? Don't understand your scenario. You load a database field as an inputfield, change it and then you want to change it back to the database value?? What for does it have to be an inputfield?

Rgds,
Joachim

AW:Refresh inputfields from SQL Server

Fri, 18 Jun 2010 10:10:09 GMT

Well, ok.

I have an SQL database with financial quotes of my own portfolio.

I want to change the current market price of the securities manually to make what-if analysis.

That's why I load a database field as an inputfiled.

Then I want to change that value once again, but I dont know, what was the original value, so I want to refresh data from database.

AW:Re: AW:Refresh inputfields from SQL Server

biester — Fri, 18 Jun 2010 10:43:14 GMT

I would load the field twice, once you can define it as inputfield.e.g.:

INPUTFIELD WHAT_IF_PRICE;
LOAD ..... PRICE,PRICE as WHAT_IF_PRICE .....;

Then you have an inputfield to set up your what if analysis and also the original values.

Rgds,
Joachim

AW:Re: AW:Refresh inputfields from SQL Server

Fri, 18 Jun 2010 11:09:34 GMT

I'll try this. Thank you.