Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Using a qlikview front end as a data entry form

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

6 Replies
fosuzuki
Valued Contributor II

Using a qlikview front end as a data entry form

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

Not applicable

Re: Using a qlikview front end as a data entry form

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

Not applicable

Using a qlikview front end as a data entry form

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

Using a qlikview front end as a data entry form

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

Not applicable

Using a qlikview front end as a data entry form

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.

Not applicable

Re: Using a qlikview front end as a data entry form

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

Community Browser