topic Re: Automate QlikView process? in QlikView

Automate QlikView process?

punitpopli — Thu, 05 Nov 2015 18:43:11 GMT

Hi All,

I have a requirement where i have to automate the QVD i.e Extract Transform and load process.

I had read some of the community posts and blogs and found that using tasks in publisher we can achieve this but this approach doesnt support onReload, postReload and onopen triggers and in my aaplication I am using on open and post reload triggers.

Can you please suggest what all options we do have to achieve this?

Thanks,

Punit

Re: Automate QlikView process?

Oleg_Troyansky — Thu, 05 Nov 2015 19:39:50 GMT

If you cannot use Publisher, then your only other option is to call QlikView from the Command Line and use Command Line parameters to reload, set variables, etc... Look up "Command Line" in the Reference Manual for more details.

Then, you can place multiple command line calls into a Windows batch file and schedule these tasks using Microsoft Windows Scheduler.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Automate QlikView process?

Anonymous — Thu, 05 Nov 2015 19:49:34 GMT

You could take a swerve and question why you have these triggers.

Also there could be better ways of achieving the same end result without the triggers.

Re: Automate QlikView process?

punitpopli — Fri, 06 Nov 2015 06:21:14 GMT

Hi bill.markham‌,

We have a requirement where we have to display default selections based on user group and because of which we have implemented on open trigger were implemented and user also want default selections to cheive this we have implement post reload trigger which run a macro post reload and set the default selections.

Could you please suggest better approach to implement this?

Thanks,

Punit

Re: Automate QlikView process?

Anonymous — Fri, 06 Nov 2015 06:25:49 GMT

Well, you can go for Batch file as well:

How to create a batch file

Batch file script to reload Qlikview Applications

Re: Automate QlikView process?

Anonymous — Fri, 06 Nov 2015 17:46:49 GMT

Assuming your needs are :

A qvw with data accessible to all users
Specific users to have easy access to specific data selections

Options could include :

Rely on the fact that when a user working via AccessPoint makes selections and then exits the qvw, then the next time they open the qvw it will open with the selections they last used.
Or create a vUserGroup variable that creates a suitable expression dependent of the value returned by the OSuser() function that can then be used in your expressions for Set Analysis to filter to only show their required data. Then you could create a button/text box to switch the Set Analysis between User Group data and All data

Or if you want to only give access to User Group specific data then use Section Access.