topic Re: Data entry form in QlikView

Data entry form

Wed, 20 Jul 2011 13:21:54 GMT

Good day to all,

anyone have any idea how to create a data entry form in QlikView with or without external code modules, or if there are facts that can be integrated already in the QV or where can I find them?

thx for all help

best reguards

Gianluca

Re: Data entry form

matt_crowther — Wed, 20 Jul 2011 13:51:22 GMT

Attached is an example file that is about as close as you can get to inputs into Qlikview - it simpl isn't designed to do that.

Other solutions could be a series of Input Boxes linked to variables.

Hope that helps in some way,

Matt - Visual Analytics Ltd

Data entry form

Thu, 21 Jul 2011 08:18:21 GMT

Thanks for help Matt.

bye bye and have a nice days.

Gianluca

Data entry form

derekjones — Thu, 21 Jul 2011 09:37:36 GMT

Hi Matt

I've just looked at your excellent example and I'm scratching my head on how you have made the fields updateable. Can you tell me where you can set this property as I can't seem to find it in any of the settings?

My thanks in advance

Derek

Data entry form

matt_crowther — Tue, 26 Jul 2011 14:08:00 GMT

Derek,

I have to admitt I wasn't the first person to come up with this concept.

However the key area to look at is the 'InputField...' command near the start of the load script; this sets the listed fields to be updatable.

For calculations you simple use the inputsum() function which is great for sales people to adjust their forecasts to see how it plays out and for comments simply add the column from what I can tell.

Hope that helps,

Matt - Visual Analytics Ltd

Data entry form

derekjones — Tue, 26 Jul 2011 14:15:02 GMT

Thank you Matt.

Re: Data entry form

eladsense — Wed, 01 Jul 2015 08:37:33 GMT

actually there is a very simple "all in one" solution for it - klikins

www.klik-ins.com

you can enter verbal or numeric data, edit it, customize your reports, input fields, sub totals in straight type or complex pivot tables, save data from the app (dashboard) straight to your DB or temporarily save it to enable future editing and many more complex functions made easy.

Re: Data entry form

Anonymous — Thu, 17 Sep 2015 08:53:40 GMT

try:

http://www.apparo.software