Button to record user usage

Asked By Martha Alfaro 60 points N/A Posted on - 07/24/2012

Hello everyone

I am using a QV dashboard with 10 different users. My issue is that I want to know which of my user and when is using the dashboard. I have contacted the QV support but they say that it is not so easy to record this activity.

So I want to try doing it myself and for this reason I need your ideas. First of all I tried doing this by hiding all the sheets except bar 1. On this sheet I tried to put a button which when toggled will show all the sheets.

I assumed that I will use a macro to update an excel file on the s drive with data based on users info and so I will successfully have a record of all the users who used dashboard with their respective timings.

Please see the attached image.

"QlikOck
Macro parse failed.Functionality was lost
WriteUsageLog
Error:ActiveX component can't create object: 'Excel.Application'"

Is it really possible and is it safe to do so?

I need your sincere suggestions.

Looking forward to hear from you

Regards

William

• Status: Open
• Question Views: 1537
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Manhathen Den 5 points N/A #139355

Button to record user usage

This error occurs because of out of date IE-Plugin. So what you need to do is to download and install the latest version of IE-Plugin so that you cannot encounter any error. When you are going to update QlikView, you need also to update the IE-Plugin, so that’s the error here.

You update the QlikView but never update the IE-Plugin.  For you to really know the problem, check the server version that you are using there and then do what I suggest, update IE-Plugin. After that, see if the error fixed. I am pretty sure that caused the error.

Good luck.

About Manhathen Den

Questions
1

Answers
151

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 07/24/2012
• Question Category: Misc Software