Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Automated excel creation failed while reloading through QMC,
when i manualy loaded the QVW the excel file is created and updated.
I want at the time QMC relaods the QVW excel file also gets updated.
so i use document properties->triggers->after post relaod->macro which creates the excel file.
But is is not working with QMC when i manualy reload qvw it is working and excel file is updated.
Is it so that through QMC the macro is not enable?
Could u please share screenshot of macro.bat file..
Batch File
"C:\Program Files\QlikView\qv.exe" /l /noSecurity "D:\Qlikview Applications\Email_Distribution.qvw"
EXIT
Hi Vikas,
Thanks Vikas,
Yes through Task scheduler the excel is created automaticaly,but now i am facing another issue.
The excel which is created is having different date columns with different format .
For Eg:-
Cust Name Service Customer Order Date Order Delivery Date Order Completion Date
ABC An68235 19-Jul-2013 9:40:12 21-Jul-2013 8:50:12 07/30/2013
DEF Def23234 09-Apr-2012 9:40:12 19-Apr-2012 10:40:12 04/25/2012
The "Customer Order Date " and "Order Delivery Date" is having the DD-MMM-YYYY hh:mm:ss format
and "Order Completion Date" is having MM/DD/YYYY format.
when i use macro then in excel these dates are in format YYYY/MM/DD hh:mm:ss.
Please help me in this.
Hii,
You can fix date format in qlikview main tab using following command
SET DateFormat='DD/MM/YYYY';
So that you can set all date formats as std.
Hope this help you.
Vikas
Hi Vikas,
Again facing one issue ,previously i created task in task scheduler by having the setting that 'When the user is logged on' and in security options it is defined as to use my account but i m not administrator.
When i use the option 'Run whether user is logged on or not'
the task fails as i logged off from the server.
The screenshot which u attached in that u used the option in security options ' Run whether user is logged on or not'
.but when i used my task runs succesfully but the excel is not generated.
Plaese me in this.
Click on General Tab -> Select Change Users or Groups tab -> Click on Advanced Tab -> Search for Administratorss -> After selecting this windows scheduler will works no issue , Here I have no problems with this setting.
I am attaching screens for setting.
Good Luck.
Vikas