Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Budget Requirement

Hello:

I'm able to show a table like this

Sales.JPG

I would like to add a new column with the budget ... but I don´t have this data in any DB available. What I need is show an empty column then the user will fill the values and save (insert/update) it to a external database (qvd or access database or a DB2 table).

Budget.JPG

Which are the Best Practices and recommendations to do a task like this ?

Any kind of help will be apreciated

Thank you very much

Joaquín

1 Solution

Accepted Solutions
JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Hello:

In a straight table I've used INPUTSUM() ... but It's hard to add this new input field in my data model.

Regards

Joaquín

View solution in original post

8 Replies
qlikmsg4u
Specialist
Specialist

Take a look at INPUTFILED function

INPUTFIELD Budget;

Test:

Load * Inline [

Name,Date,Sales,Budget

John,12/12/2009,1200

Jeff,11/11/2009,300

];

You can able to enter data into Budget field through front end

swuehl
MVP
MVP

A very basic approach would be to export the table to Excel, fill in the values and then reload the QVW with the updated Excel.

You may also want to look into QlikMarket and search for planning tools, e.g.

KliqPlan (Planning Suite)

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Hello QLIKmsg4u:

Thanks for your help.

This is the first step, how can I save the inserted values in an external database ?

Joaquín

qlikmsg4u
Specialist
Specialist

As swuehl Suggested you can export table data to excel or .qvo object and reload the document with updated file

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Thanks swuehl

I will have a look

Joaquín

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Hello K N:

I've just tested your suggestion, the qvw stored the new values inside the document.

In which conditions can the user lose the data ?

Do I have to make a backup of any file ? ... we have QV 11 SR12 with Server & Publisher PDF

Joaquín

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Hello K N:

One more step. I would like to change the SalesMan column by a two items group Company/SalesMan and the year column by another group Year/Month.

If I have facts table with thousands records, which is the best practise to use the INPUTFIELD ?

Thank you

Joaquín

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II
Author

Hello:

In a straight table I've used INPUTSUM() ... but It's hard to add this new input field in my data model.

Regards

Joaquín