Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Button to record user Usage

Hi Experts

I have a QV dashboard with 10 different users, I need to know who is actually using the dashboard and when ( Its an internal debate issue !!)

Our support have told me that there is no easy way to record this so I was thinking that ( AND I DONT KNOW IF THIS IS POSSBLE)

as a work around --

Hide all sheets - bar one

On this sheet put a button that when toggled

shows all sheets and

*Presumably uses a macro to update an Excel file on the s drive with data based on users info

-- Hence I would have a log of all users!!!

Has anyone got any feedback on this ?


Do you think its possible?

Should I not even try and persue it ?

Any advice greatly appreciated

Thanks


A

1 Solution

Accepted Solutions
mwoolf
Not applicable

Re: Button to record user Usage

Take a look at the attached qvw.

22 Replies
mwoolf
Not applicable

Button to record user Usage

Yes, this is possible.

Use osuser() to get the userID

You will find many posts telling you how to write to an Excel file.

Not applicable

Button to record user Usage

Thanks mwoolf!!!

Ill start research mode so

mwoolf
Not applicable

Button to record user Usage

A problem that you may encounter is that users will have to accept System Level macros when they open the application.

There are some posts that describe how to force this through registry entries.

If you can be sure that users have accepted system level macros, you don't need to use a button or hide any sheets.

You can set a macro to run when the document is opened.

Not applicable

Button to record user Usage

Hey Mwoolf

I have never successfully used macros in QV , today this will change !!

I have seen that message and to be fair to our users they tend to always check for allowance,


its easy enough for me to communicate with them to allow them anyway !!

Do you have any sample of a QV macro that runs on open , or any macro that I can look at ?

mwoolf
Not applicable

Re: Button to record user Usage

Take a look at the attached qvw.

Not applicable

Re: Button to record user Usage

Mwollf

Honestly,

This is great thanks so much that would have taken me ages, if you're ever in dublin Ill get you a pint

Thanks

flipside
Not applicable

Re: Button to record user Usage

You might find the Audit logs of interest for this requirement which reside at ...

C:\ProgramData\QlikTech\Qvs on the server, but you will need to switch on client activity logging in QEMC.

flipside

Not applicable

Button to record user Usage

QV Error.bmp

Hey Guys

It seems to be working fine for developers on the Server but those using a viewers license are getting the following message

-- Any suggestions ?

Thanks

A

mwoolf
Not applicable

Button to record user Usage

They either don't have Excel or they haven't set System Level Access.