There are a number of reasons you may want to upgrade to QV12, I’ll be posting about them in the next few weeks. Today’s post is specifically about what you must address to upgrade to QV12.
There are two items I’m aware of that you must be aware of and consider before upgrading.
- QlikView version 12 Server changes the default permission for the EXECUTE script statement More details in this post.
- In QlikView 12, QVD functions now respect the DIRECTORY statement. This is a breaking change that may cause some of your QV11 script to return incorrect results or take incorrect conditional actions. More information in a post here.
So again, I’ll be blogging about new features you may want to take advantage of, but above are the only two items I know of that you must consider before upgrading.
How do you know if you are using the impacted EXECUTE statement or QVD* functions? Perhaps you already have a tool in place to answer that question. But if you don’t, my colleagues at the Masters Summit for Qlik are making the Script Repository Tool (“ScriptRepo”) available for public download.
If you have attended a Masters Summit, then you already have a copy of ScriptRepo in your takeaways. if not, we would love to have you attend a Summit. But the Masters Summit Team understands the universal need for a tool like ScriptRepo whether you can attend the Summit or not.
The “ScriptRepo” tool extracts script from a directory of QVWs and then allows you to do a global search for script of interest such as “Execute”. Plug in the directory path that contains qvw files, and a temporary work directory to extract the script into:
Press the “Extract & Reload” button and each QVW file in the input directory will be opened and the script extracted. The open is done with “nodata”, so the extraction runs relatively fast — about one qvw per second.
After extraction, you can use your favorite search tool to scan the output directory, or use the builtin QlikView search & display from the “Script Search” sheet.
After searching for “customer” and selecting a candidate qvw:
I hope to see you at the Milan Summit in April 2016 or a USA location in Fall 2016. If you have questions about the Summit or using the ScriptRepo tool, let us know through the QlikView Cookbook Contact form or the Masters Summit Contact page.
-Rob