topic How to pass comments from one sheet to Home page in QlikView

How to pass comments from one sheet to Home page

Mon, 04 Apr 2016 07:10:26 GMT

Dear all,

We have multiple reports in multiple sheets and have input box in each sheet(report) for user to provide comments which is allowed only when Reviewed mark(text object) is clicked in sheet and then both comments and review status i.e 'Reviewed or Not Reviewed' should be updated in Home page (in a straight table which is having report names as dimension and comments and review status as expressions).

Here, issue is when user provide review status and comments in one sheet/report , those values are being updated in Home page i.e in straight table but they are being updated for all rows(i.e all dimension values) where we expect that updation should happen specific to each sheet.

Please find that attachments and let us know your valuable suggestions.

Thanks in advance.

Regards,

Kishore.

Re: How to pass comments from one sheet to Home page

kaushiknsolanki — Mon, 04 Apr 2016 09:25:03 GMT

Hi,

Hope this will solve your problem.

Regards,

Kaushik Solanki

Re: How to pass comments from one sheet to Home page

Mon, 04 Apr 2016 12:05:32 GMT

Perfect.Its working fine.

Thanks a lot Kaushik. Your quick response is much appreciated.

Re: How to pass comments from one sheet to Home page

kaushiknsolanki — Mon, 04 Apr 2016 12:33:23 GMT

Great

Regards,

Kaushik Solanki

Re: How to pass comments from one sheet to Home page

Tue, 12 Apr 2016 13:35:53 GMT

Hi Kaushik,

Can you please provide the suggestion on below thread.

How to pass comments from multiple sheets to Home page specific to month wise

Thanks in advance.