Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help to create Folder named today date and store current QVW

Hello everyone,

I want to create a folder which name must be today() like 26/06/2014,and it contains the QVW file which is created or updated on today().

and again when I Reload the application tomorrow it will create a new folder with name 27/06/2014 and store the updated QVW file.

How is this possible,if anyone has idea please share with me.

Thank you in advance.         

1 Solution

Accepted Solutions
Not applicable
Author

I found the solution which works fine. thank you Gysbert for your help..

this is the batch file coding,

@echo off

set yy=%date:~-4%

set mm=%date:~-7,2%

set dd=%date:~-10,2%

set MYDATE=%dd%-%mm%-%yy%

md %MYDATE%

"c:\program files\qlikview\qv.exe" "C:\Users\Administrator\Desktop\qlikview\my\Sample apps\button.qvw" 

copy "C:\Users\Administrator\Desktop\qlikview\my\Sample apps\button.qvw" %MYDATE%

pause

View solution in original post

5 Replies
Gysbert_Wassenaar

You'll have to use some sort of batch script. Perhaps something like this (untested):

@echo off

For /f "tokens=2-4 delims=/ " %%a in ('date /t') do (set mydate=%%c-%%a-%%b)

set mydir="%mydate%"

mkdir %mydir%

"c:\program files\qlikview\qv.exe" /r "MyDoc.qvw"

copy "MyDoc.qvw" %mydir%


talk is cheap, supply exceeds demand
Not applicable
Author

and how would I run this batch file,is there any macro code to run this batch file?

Gysbert_Wassenaar

Put a line like the one below in the script of the qlikview document:

execute cmd.exe /c "c:\myfolder\mybatchscript.bat"


talk is cheap, supply exceeds demand
Not applicable
Author

I found the solution which works fine. thank you Gysbert for your help..

this is the batch file coding,

@echo off

set yy=%date:~-4%

set mm=%date:~-7,2%

set dd=%date:~-10,2%

set MYDATE=%dd%-%mm%-%yy%

md %MYDATE%

"c:\program files\qlikview\qv.exe" "C:\Users\Administrator\Desktop\qlikview\my\Sample apps\button.qvw" 

copy "C:\Users\Administrator\Desktop\qlikview\my\Sample apps\button.qvw" %MYDATE%

pause

vignesh_s
Creator
Creator

how to obtain date formate "mm" as "mmm"