Assistance Required: Identifying QlikView Applications with Macro Functionality
Hi, Good Morning,
I’m currently working on identifying which QlikView applications contain macro functionality. Since there are numerous `.qvw` files, I’ve been using a PowerShell script to scan a specified directory and generate a report indicating whether each file contains macros.
However, the script is not producing the expected results. The output I’m receiving differs significantly from what I anticipated.
- **Expected Output:** Please refer to the attached file `Expected_Sample.txt`. - **Actual Output:** Located in the folder `Real Output`. - **Script Used:** Attached for your reference.
Could you please assist me in troubleshooting this issue or suggest a better approach to achieve the desired outcome?
I don't know powershell enough to suggest what may be the problem here. What I can do is point you to a couple of utilities where I do something similar, but with VbScript inside QlikView.
QV Document analyzer extracts metadata, including Actions, from a QVW. You could copy some code from the QC Doc Analyzer Module that extracts Actions into a copy of the aforementioned Script Repo and record the macro calls along with the module extract.
I know may be simpler if you could fix the PS script 🙂
In addition you may look into the APIGuide.qvw to get hints for the available properties and needed syntax as well as various example-code. And like Rob hinted it might be more pragmatic to take the nativ VBS instead of transferring it to PS.
