Using a qlikview front end as a data entry form

[#1]

Hi all,

Is it possible to set up a qlikview front end that acts as a data entry form?

I'm thinking along the lines of the following:

* Input variables created for each of the data entry fields

* User inputs into these variables in the qlikview front end (via accesspoint)

* A macro saves this data onto a spreadsheet or into a qvd.

Many thanks

Dan

[fosuzuki]

Hi Dan,

First of all, I must warn you that I'm not really an expert so please don't take my comment as a definite answer.

Yes it is possible but I would not recommend, since QlikView's purpose is not to behave as a transactional system.

One possibility is to work with variables, as you described, and this will serve you fine if the amount of information to input is small. If the user has a lot of info to input, this would need a lot of variables and it may become difficult to create and maintain the code.

Another possibility is to work with inputfields instead of variables. This may serve your needs, but I alert you that it is very tricky to use them, and maybe you will not be able to build a friendly user interface. I've had a lot of headaches to make them work...

Regards,

Fernando

[#3]

I have attached a file that we use for users to enter comments into an excel file that links to cost center expense items.

I too must warn you that QlikView is not really ment to capture data - only report on it.

Stephen

[#4]

Hi Dan,

As others suggested, QlikView is designed to build reports but not to capture data from users.

Further to that if you wish to capture data from QlikIVew, try developing data capturing componenet as ActiveX COM object and try to embed it in your application using Custom Object.

Alternatively, QlikView provides you SDK using which you can embed QlikView applications in to other application. So you can develop a front end using ,NET technologies and embed QlikVIew application within that UI.

HTH

Ravi

[chriscammers]

Just to satisfy my own curiousity, is there an option with extensions?

[#6]

Sounds great about using an activex object or using an SDK or using extensions.

Don't have a clue how to use these though!

We have a working solution now using variables saving out using a macro to a csv file. Its very basic but works. Downside is that we have to use the IEplugin version, it won't work at all over AJAX.

[#7]

thanks stephen. Chris. extensions are there for smart data entry.