topic macro to write the script from the current QVW to a excel in QlikView

macro to write the script from the current QVW to a excel

Wed, 25 Nov 2020 16:16:04 GMT

Hello All

I want a help regarding a macro , the macro will get the script of qvw and will copy it to execl file for comparison purposes.

thnk you.

Re: macro to write the script from the current QVW to a excel

bindu_apte — Wed, 24 Aug 2016 03:52:24 GMT

Hi Sunny,

Hope this threads will help you.

QlikView Macros – Useful collection | Lucian Cotea

Qlikview to excel export macro

Useful Qlikview Macros

Re: macro to write the script from the current QVW to a excel

tresB — Wed, 24 Aug 2016 05:05:25 GMT

I am not sure if there is any macro to export the script. However, you can easily do it from script editor:

Ctrl+E -> Alt+F+E , you can save in your desired format as well.

Re: macro to write the script from the current QVW to a excel

Anil_Babu_Samineni — Wed, 24 Aug 2016 05:17:03 GMT

Amit, I accept that. Few days back I've got the same thought. That time some one help about the qvw script to specific format. Might be someone help sunny

Re: macro to write the script from the current QVW to a excel

marcus_sommer — Wed, 24 Aug 2016 05:51:48 GMT

You could use a macro like this: Re: Macro to export Script to get the script and something like this: Macro to paste Text Object in Word to insert it into word - than word is a lot more suitable if you want to compare various scripts or search within them. Where it's not necessary needed to include the script directly into word - saving as txt-file will be enough than word could open them.

Maybe even better would be you used notepad++ with the compare plugin: Notepad++ Compare plugin download | SourceForge.net and the qlik script-language: Re: QlikView in Notepad++‌.

- Marcus

Re: macro to write the script from the current QVW to a excel

Wed, 24 Aug 2016 13:11:11 GMT

yup, I followed the link that you have given and with help of macro code I got the scipr copies into a qvs file. Then i can use it for comparison by some tools available. That solves the issue. Thank you for support.