Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

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

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
6 Replies
xavieravinson
Contributor III
Contributor III

Hi

    It's  not possible to enter a Data.

Thanks & Regards

XavieRavinson

vardhancse
Specialist III
Specialist III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vardhancse
Specialist III
Specialist III

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

Not applicable

Hi,

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

But writing into the database is not possible.

eladsense
Partner - Contributor II
Partner - Contributor II

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.