topic Re: Qlikview Macro replacement challenge in App Development

Qlikview Macro replacement challenge

praveenr035 — Tue, 20 Apr 2021 19:04:40 GMT

Hi, we are facing challenges with maintaining Qlikview reports that have macros and users running via IE plug-in set-up.
With recent windows update, the IE plug-in version of report became too slow to handle. I am looking for ways to redesign a specific report, can someone please help out how best I could achieve this functionality without macro? just fyi - we do have qliksense option

Functionality:
Macro 1: Runs on any user selection (document properties -> triggers).
Functionality: Based on user selection, macro assign values from straight table first row to Qlik variables

These variables are assigned to input box so users can edit them and click on a button

Macro2: Runs on a button click
Functionality: Extracts variable strings and pass them (as arguments) to run a batch script. The output of batch script is a file. VB script macro script reads the content of file and store it back in a Qlikview variable.

Looking for ways to re-design this functionality in Qlikview or Qliksense. I appreciate any help in this regard.

Thanks in advance!

Re: Qlikview Macro replacement challenge

Dalton_Ruer — Tue, 20 Apr 2021 19:43:50 GMT

If you do this in Qlik Sense you can use button actions that will assign the values to variables so that the end user can then change them as desired.

QlikView and Qlik Sense both permit you do a Partial Reload. Which allows you to invoke the load script again but not have to actually load all of your data again. You can simply invoke the section of code that will do the EXECUTE that you wish to do and reload the data from your integration programs output.

I created a YouTube video about using extensions in Qlik Sense SaaS. The reason I bring it up is that I showed a demonstrated a really neat extension for doing partial reloads that is very visual while the reload is occurring.

Re: Qlikview Macro replacement challenge

praveenr035 — Wed, 21 Apr 2021 12:18:29 GMT

I'm new to Qlik Sense. Thank you Dalton, your post is enligtening