Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I have the next issue.
I open .qvw file -> I change in script one row in FROM function:
[SalesPrice_Files_$(vSourceFileMonth)01.qvd] -> [$(vSourceFilePath)SalesPrice_Files_$(vSourceFileMonth)*.qvd]
than I save file and after that my file is broken.
At the same time, there is another file with this row([$(vSourceFilePath)SalesPrice_Files_$(vSourceFileMonth)*.qvd]) that works fine.
Does anybody know what may be reason?
It sounds like the QVW is corrupt. are you able to open it with no data?
Open QlikView and open the start page (if not already open). and from the recent documents list, right click the document in question and select open without data.
If that opens, just reload it and save.
At the same time, there is another file with this row([$(vSourceFilePath)SalesPrice_Files_$(vSourceFileMonth)*.qvd]) that works fine.
That's pretty amazing considering Qlikview doesn't have a row() function.
I suggest you turn on the Generate logfile option in the Document Properties. And that you open the Script Editor to reload your document while using the Debugger. That way you can see where the error occurs, the message that generates and the values of your variables at that time.
So the error appears when you click SAVE? does the QVW actually save?
The error you have shown says the QVW failed to load. I'm sure that's an on open error
My steps are:
1. I change script;
2. I save file;
3. I close file;
4. I open file -> file broken
Thanks!
Sound like a corrupt document. Can you try to create a new file with only the script of the other file? Does that also give the same error?
I can recreate file and copy this script and it would be work.
But after a while some file will be broken again. And I can't find a cause.
Thanks!
Perhaps it's your harddisk that's the problem. Have you checked that out yet?