Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two qlikview fi. First one to create a QVD file and 2nd one to obtain sales data by loading QVD file. I want to run these files at 6.30 am daily. Pls help me to automate the file loading
Hi,
You need QlikView Server to do this.
Other option Reload from Batch File.
Batch file script to reload Qlikview Applications
Regards,
Kaushik Solanki
Do you have a QV Server installation?
Andy
No
You can use batch file to schedule and run the files
Can you pls send me a sample batch file
U want to generate logs n all or??
Or just reload?
Hi Upali
Go through these Documents and Links:
https://skillforge.com/qlikview-scheduled-update-of-qlikview-reports/
https://community.qlik.com/docs/DOC-5412?_ga=1.32643006.1495895207.1487063719
This will help you out.
Regards
Av7eN
FOR /F "TOKENS=1* DELIMS= " %%A IN ('DATE/T') DO SET CDATE=%%B
FOR /F "TOKENS=1,2 eol=/ DELIMS=/ " %%A IN ('DATE/T') DO SET mm=%%B
FOR /F "TOKENS=1,2 DELIMS=/ eol=/" %%A IN ('echo %CDATE%') DO SET dd=%%B
FOR /F "TOKENS=2,3 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET yyyy=%%B
rem FOR /F "TOKENS=2,4 DELIMS=/ " %%A IN ('echo %CDATE%') DO SET HH=%%B
for /f "tokens=1-5 delims=:" %%d in ("%time%") DO SET HH=%%B
if %MM%==01 set MM=JAN
if %MM%==02 set MM=FEB
if %MM%==03 set MM=MAR
if %MM%==04 set MM=APR
if %MM%==05 set MM=MAY
if %MM%==06 set MM=JUN
if %MM%==07 set MM=JUL
if %MM%==08 set MM=AUG
if %MM%==09 set MM=SEP
if %MM%==10 set MM=OCT
if %MM%==11 set MM=NOV
if %MM%==12 set MM=DEC
SET setd=%dd%%mm%%yyyy%
echo %setd%
set filename=Give name_%setd%.log
echo %filename%
set var=--------------------------------------------------------------------------------------------------------------------------
set QVEXE="C:\Program Files\QlikView\Qv.exe"
Set Path="GIVE PATH_%setd%.log"
REM...................................................Extractors.....................................................................
Rem -----------Batch Start--------------------------------------------------
Set QVReport="E:\GIVE PATH\Name.qvw"
echo %DATE% %TIME% Loading started For %QVReport% >> %Path%
%QVEXE% /r %QVReport%
echo %DATE% %TIME% Loading ended For %QVReport% >> %Path%
echo %var% %var% >> %Path%
Rem ---------------Batch End----------------------------------------------
Hi Bold letter plss take care..Chech whtr QV.exe in path..Give ur file names..Plss try
Sachin