topic Scheduling according to the time(hours) selecting from the inputbox in QlikView

Scheduling according to the time(hours) selecting from the inputbox

Tue, 21 Jun 2011 05:49:37 GMT

Hi,

I am using Qlikview personal edition.

Can any one help me in this.

I have the Qlikview file and it contains data that is comming from the database and i implement Incremental load also.

I have the inputbox it contains time in hours.according to the selection of any of that hours the data must be refreshed that means the incremental load should be done according to that inputbox times.

it contains Hours like 4,8,12,16,24.

if you want any details regarding this i will explain.

Is it possible to do?

Please reply me........

Thanks....

Scheduling according to the time(hours) selecting from the inputbox

kaushiknsolanki — Tue, 21 Jun 2011 06:31:18 GMT

Hi,

As per my knowledge its not possible to schedule any qlikview documents without qlikview server.

If you want to have incremental load you have to manually do the reload action.

Regards,

Kaushik Solanki

Scheduling according to the time(hours) selecting from the inputbox

Tue, 21 Jun 2011 06:49:00 GMT

Hi Kaushik,

Thanks for your Reply

ok fine,

Can you send the procedure to do how in server that satisfies my requirement in previous post.

Thanks.......

Scheduling according to the time(hours) selecting from the inputbox

kaushiknsolanki — Tue, 21 Jun 2011 06:52:44 GMT

Hi,

You can not use servere functionality without proper license.

Server is not freely available.

Regards,

Kaushik Solanki

Re: Scheduling according to the time(hours) selecting from the inputbox

Miguel_Angel_Baeyens — Tue, 21 Jun 2011 06:57:31 GMT

Hi,

Although it's not an alternative to QlikView Server, because it adds more functionality and control on the reload process, you can use the Scheduled Tasks in Windows and use a command line batch file (.bat) to reload a document, without having the Server.

Using the following single line in an empty text file (later renamed to .bat) will do the reload.

"C:\Program Files\QlikView\qv.exe" /r "C:\QlikViewFiles\File.qvw"

Now that you have a .bat file, you can schedule the load in the Windows button, Accessories, System Tools, Task Scheduler.

If you want to pass a variable on to the document, you can do that as follows

"C:\Program Files\QlikView\qv.exe" /vVariableName=Value /r "C:\QlikViewFiles\File.qvw"

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Scheduling according to the time(hours) selecting from the inputbox

Tue, 21 Jun 2011 09:14:27 GMT

hi Miguel,

Thanks for your post.

I have created one bat file. Now how should i run that bat file from the windows schedular?

Can you explain me the process clearly..

and for the variable passing i wrote like this, check wether it is correct or not.

"C:\Program Files\QlikView\qv.exe" / vRefresh /r "D:\kumar\RTQ\Qlikview Files\FiltersFinal -Copy.qvw

Thanks.....

Re: Scheduling according to the time(hours) selecting from the inputbox

Miguel_Angel_Baeyens — Tue, 21 Jun 2011 09:33:49 GMT

Hi,

To get to the Windows Task Scheduler, go to Windows button (as I mentioned above), and in your program list, click on the Accesories folder, System Tools folder, and there you have the Task Scheduler. Create a new task, set it to trigger every four hours, once a day or whatever, and use the BAT file as action.

In regards to variables, say you have a variable in your script named vRefresh and you want to pass "1" as value for that variable, then the bat file should contain the following line

"C:\Program Files\QlikView\qv.exe" /vvRefresh=1 /r "D:\kumar\RTQ\Qlikview Files\FiltersFinal-Copy.qvw"

You can find the complete list of paramters to use in the command line in the Reference Manual. Quotes as showed above are needed.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: Scheduling according to the time(hours) selecting from the inputbox

Tue, 21 Jun 2011 12:01:16 GMT

Hi Miguel,

I followed your steps but it is not reloading the QVW file when Scheduled for particular time.

1.) Where the .bat file should place in my system.

Pls see the image attachements what i had done in SchedulerTask.

If any modify should done in my process, pls reply me.

Thanks

venkat

Re: Scheduling according to the time(hours) selecting from the inputbox

Miguel_Angel_Baeyens — Tue, 21 Jun 2011 12:15:57 GMT

Hi,

Is the system double quoting the program name? Is the drive 😧 accesible by your user? Give a try removing those quotes. Your file must be anywhere in the computer (or network) provided this location is available to the user running the task.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Scheduling according to the time(hours) selecting from the inputbox

Wed, 06 Jul 2011 15:44:41 GMT

Hi Venkat,

NPrinting allows you to schedule QlikView documents reload in QlikView personal edition. You can also design and generate reports and schedule the distribution of reports filtered with user specific filters. No .bat files or macros to develop and maintain.

Download the full featured free trial here: http://www.nprinting.com/free-trial/

Best

The NPrinting Team