Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

joaquinlr
Valued Contributor 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
joaquinlr
Valued Contributor II

Re: Budget Requirement

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
Valued Contributor

Re: Budget Requirement

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

Highlighted
MVP
MVP

Re: Budget Requirement

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)

joaquinlr
Valued Contributor II

Re: Budget Requirement

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
Valued Contributor

Re: Budget Requirement

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

joaquinlr
Valued Contributor II

Re: Budget Requirement

Thanks swuehl

I will have a look

Joaquín

joaquinlr
Valued Contributor II

Re: Budget Requirement

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

joaquinlr
Valued Contributor II

Re: Budget Requirement

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

joaquinlr
Valued Contributor II

Re: Budget Requirement

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