Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is Gangadharan
I am facing the problem in one of my .qvw. Its always asking save as instead of save.
Can anyone help on this..
Hi,
we are facing the same problem... is there new information about it?
Thanks,
Martin
Martin,
Do you have section access in your application.
If you have section access in your application, Qlikview would always ask for 'save as' instead of 'save'.
- Sridhar
Yes we do. Thank you.
Martin
How to handle this problem when doing a automatic reload say with /r command line option ?
Hi,
it seems it only happns if you change somthing in the document. only reloading will not trigger the "save as"
any change to the layout or the script will cause it to trigger the "save as" instead of just "save"
that kinda makes it imposiblle to run a macro that reduces rows and then save automaticly.
wish there was a way to simulate pressing the OK button on the "save As" dialog but there is none i can think of.
Hi,
got the same problem 'cause I'm using Reduce data macro after reload, so I edit my macro adding 2 lines:
----------------------------
sub AfterReload
ActiveDocument.Fields("%cod_società").Select "4090"
ActiveDocument.ReduceData
ActiveDocument.SaveAs "path\filename.qvw"
ActiveDocument.GetApplication.Quit
end sub
------------------------------
This force the save as with the same filename.
For reload i'm using PsExec:
psexec "C:\Program Files (x86)\QlikView\Qv.exe" /L /NoSecurity "path\filename.qvw"
Hope this can help,
Luca
I know this thread has been around awhile, but I was having this same problem and needed to use a relative path in the macro. This solution will work in that scenario:
*note QvWorkPath is a system variable
----------------------------
sub AfterReload
Dim strPath
strPath = ActiveDocument.Variables("QvWorkPath").GetContent().String
Dim strFilename
strFilename="\filename.qvw"
Dim strPathFilename
strPathFilename=strPath&strFilename
ActiveDocument.Fields("%cod_società").Select "4090"
ActiveDocument.ReduceData
ActiveDocument.Saveas strPathFilename
ActiveDocument.GetApplication.Quit
end sub
----------------------------