topic Re: Input Field in Pivot table accept data from users and store into sql write back in QlikView

Input Field in Pivot table accept data from users and store into sql write back

vikasmahajan — Wed, 12 Aug 2015 06:36:13 GMT

Hii,

Dear all,

I want demo for imputing data into pivot table (input inline ) , like comments and other fields as input store into vars and save to sql database.

Does anybody have example for the same , Please share.

Thanks

Vikas

Re: Input Field in Pivot table accept data from users and store into sql write back

xavieravinson — Wed, 12 Aug 2015 06:39:36 GMT

It's not possible to enter a Data.

Thanks & Regards

XavieRavinson

Re: Input Field in Pivot table accept data from users and store into sql write back

vardhancse — Wed, 12 Aug 2015 06:49:01 GMT

Some thing similar to your requirement can be done using Dynamic Data Option in QlikView.

Refer to the below thread

How to use Dynamic update action in QV 11

It might be useful, but the issue was that.

1. it should be enabled in both qlikview client and server as well.

2. User should be part of QlikView administrator

Re: Input Field in Pivot table accept data from users and store into sql write back

jonathandienst — Wed, 12 Aug 2015 07:01:12 GMT

Qlikview is not a tool designed for data entry - while you could ram the round peg of Qlikview into the square hole of data entry, the best you could hope for would be a clunky, unreliable and inefficient solution. My advice is, don't do it.

Re: Input Field in Pivot table accept data from users and store into sql write back

vardhancse — Wed, 12 Aug 2015 07:15:29 GMT

Hi Jonathan,

What you said is correct, but we have one requirement is that in access point while accessing the dashboard.

If user identified any bug/issue then and there he want to add a note

So advised to use add notes option in qlikview access point.

But, added comments should be displayed in a table format having some columns like username, date, sheet name and comments.

So in that case opted for dynamic data update but our platform team was not ready to enable that option.

Other than than as suggested by you, we should not use qlikview as an CRM system to add data and store in to DB

Re: Input Field in Pivot table accept data from users and store into sql write back

Wed, 12 Aug 2015 08:40:30 GMT

Hi,

You can use inputfield function to load data back into qlikview table.

But writing into the database is not possible.

Re: Input Field in Pivot table accept data from users and store into sql write back

eladsense — Thu, 27 Aug 2015 08:06:47 GMT

You can use klikins : www.klikins.com

klikins is a pretty simple extension bundle exactly for that purpose (and many more). using it you can insert and edit multiple kinds of data straight to the Qlik dashboard, into your database and vice versa.