Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
Showing results for 
Search instead for 
Did you mean: 
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


6 Replies

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...



Not applicable

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.


Not applicable

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.




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

Not applicable

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

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