Edit/Enter Commentary Option in Qlikview

[dsharmaqv]

Hi

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.

[Gysbert_Wassenaar]

Define Commentary as an InputField in the script.

[trdandamudi]

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

[dsharmaqv]

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

[dsharmaqv]

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

[Gysbert_Wassenaar]

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

[dsharmaqv]

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.

[Anil_Babu_Samineni]

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

[Gysbert_Wassenaar]

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.

[ramasaisaksoft]

Hi Deepak,

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

End-User dynamically updating Data in QVW