topic Re: Edit/Enter Commentary Option in Qlikview in QlikView

Edit/Enter Commentary Option in Qlikview

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

I have a requirement where user wants to edit/enter commentry in the reports.

For ex: Last column user want to edit/enter commentary also wanted to save it to .Qvd

Is there any work arround to achive this functionality?

Incident ID	Country	REG	Commentary
101	IND	A	edit/enter commentry
101	IND	A	edit/enter commentry
102	IND	A	edit/enter commentry
102	UK	V	edit/enter commentry
103	UK	V
103	UK	V
103	US	F
103	IND	A

Many Thanks in advance.

Re: Edit/Enter Commentary Option in Qlikview

Gysbert_Wassenaar — Tue, 08 Nov 2016 13:34:54 GMT

Define Commentary as an InputField in the script.

Re: Edit/Enter Commentary Option in Qlikview

trdandamudi — Tue, 08 Nov 2016 14:20:13 GMT

Please see the attached file for the solution. You can do the following:

1) You can edit the commentary field

2) You can save to a QVD using a macro

Hope this helps...

Re: Edit/Enter Commentary Option in Qlikview

dsharmaqv — Wed, 09 Nov 2016 07:25:23 GMT

Thats Great! Thirumala

I have few queries if you could answer those.

1. Will this solution work after publishing the qvw in server. If Yes, do I need to make any changes?

2. I am using qvd as my back hand to generate reports, and qvd is having 20-30 columns. Out of 20-30 columns I am using only 7-8 columns to display in report so how do I save the change in same qvd without impacting any other data.

Many thanks in advance

Re: Edit/Enter Commentary Option in Qlikview

dsharmaqv — Wed, 09 Nov 2016 07:33:35 GMT

If I define Commentary as an InputField in the script. How do I same my changes so that it will be available for others?

Re: Edit/Enter Commentary Option in Qlikview

Gysbert_Wassenaar — Wed, 09 Nov 2016 07:45:22 GMT

By exporting the results to a qvd or csv file are then loading them again from that file.

Re: Edit/Enter Commentary Option in Qlikview

dsharmaqv — Wed, 09 Nov 2016 08:29:18 GMT

I am using qvd as my back hand to generate reports, and qvd is having 20-30 columns. Out of 20-30 columns I am using only 7-8 columns to display in report so how do I save the change in same qvd without impacting any other data.

Can you please help me with sample.

Re: Edit/Enter Commentary Option in Qlikview

Anil_Babu_Samineni — Wed, 09 Nov 2016 08:56:48 GMT

1) It should work

2) Would you elaborate more. You may store seperate QVD for 7-8 Columns. Then, You can refer that qvd. It seems 2 diff qvd's. It never impact

Re: Edit/Enter Commentary Option in Qlikview

Gysbert_Wassenaar — Wed, 09 Nov 2016 09:04:16 GMT

Load only the incident id and the commentary from the exported file. Create a mapping table with those two columns. Then load the qvd with the 20-30 columns and use the applymap function to replace the commentary of the original table with the commentary from the export.

Re: Edit/Enter Commentary Option in Qlikview

ramasaisaksoft — Wed, 09 Nov 2016 09:58:18 GMT

Hi Deepak,

the below link will help to you for some what.both questions are approximately same

End-User dynamically updating Data in QVW

Re: Edit/Enter Commentary Option in Qlikview

susovan — Wed, 09 Nov 2016 11:07:32 GMT

Hi deepak,

you can also try this attached documents.

Re: Edit/Enter Commentary Option in Qlikview

dsharmaqv — Tue, 15 Nov 2016 11:56:27 GMT

Is there any way to achive this in pivot table?

Re: Edit/Enter Commentary Option in Qlikview

dsharmaqv — Tue, 15 Nov 2016 11:58:32 GMT

Hi I can see you are doing just a reload. Will this work in server as well?