topic Button to import excel for end user in QlikView

Button to import excel for end user

Fri, 25 Jul 2014 10:00:51 GMT

Hello -

I want to create a button on QlikView dashboard for the end user to import the excel file. The file would be a very simple few column files and would have to be completely reloaded (not incremental etc.). This would be done on the dashboard through Qlikview Access point since the end user will not have access to edit script under 'File' menu. Would this be possible?

Thanks

Re: Button to import excel for end user

datanibbler — Fri, 25 Jul 2014 10:25:24 GMT

Hi,

short answer: No - if the user does not have the client installed, he cannot trigger a reload of the app. Period.
=> You would have to build a macro to do it - and I'm not sure that would work - but macros are always resource-heavy.

If they have the client installed, you can grant them the right to reload, but not to edit the script. That would be an alternative.

If the volume of data to be reloaded is not too big, it would also be possible to just schedule it (in the QMC) to be automatically reloaded every 5min or so - would that be acceptable?

Re: Button to import excel for end user

Fri, 25 Jul 2014 11:39:39 GMT

If the user does have desktop version, would a button that would allow them the import and browse to the location of the file be possible? I am thinking I have to go that direction instead of Access point.

Thanks

Re: Button to import excel for end user

simondachstr — Fri, 25 Jul 2014 11:47:29 GMT

You can add a button which contains the action External -> Reload.

This activates a reload of the script.

If you wish for the user to be able to set the location of the files to be picked up, you can combine the button with an Input Box, which sets a variable which is then being used in the script.

Re: Button to import excel for end user

Fri, 25 Jul 2014 11:49:29 GMT

Would you have an example on how to set the variable with input box?

Re: Re: Button to import excel for end user

simondachstr — Fri, 25 Jul 2014 14:27:49 GMT

See the attached example.

The variable can e.g. hold the path where the Excel files are located and you can load their content using *.xlsx

Re: Re: Button to import excel for end user

Thu, 07 Aug 2014 01:23:35 GMT

Great this would work but how would they browse through their computer for the file? If I define the path in the variable, the path may be different on their computerl

thanks