topic Re: Data reload - testing script/presentation changes in QlikView

Data reload - testing script/presentation changes

MichalK — Thu, 01 Jun 2017 07:26:23 GMT

Hello everyone - I'm new here so I'd like to say hi to all of You.

We have app that has been created by external company - it uses SAP (Qlik Connector) to gather SAP data and some xls source files.

Data is gathered every 2 hours - apart from I have no idea how these extractors/generators work I want to make some changes to script and test it. Qvw file for main app is ~800 mb - when I make some changes in script and want to test if result is OK (let's say that I add some field or change calculations) do I have to reload data everytime (ctrl+r) and import all of those megabytes?

I know that I can also partial reload but sometimes I need to change somethin in live running app and when I partially reload my users will see only partial data (amirite?)

Please be forgiving to a freshman

Michał

Re: Data reload - testing script/presentation changes

felipedl — Thu, 01 Jun 2017 18:17:46 GMT

Hi Michal,

The script changes you do will only take effect on the next active reload of the app, either by task on QMC or manual reload (ctrl+r) you do.

For testing effects, you could use the First prefix before the load statement to test with a limited number of rows.

http://help.qlik.com/pt-BR/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptPrefixes/First.htm

Something like:

First 100

Load:

From '(file)';

To load first 100 rows of the '(file)' on the From clause for example.

Felipe.

Re: Data reload - testing script/presentation changes

neelamsaroha157 — Thu, 01 Jun 2017 18:26:49 GMT

I would suggest that don't make any change in live application until its tested. Just take a copy of existing file and play around with that.

Re: Data reload - testing script/presentation changes

MichalK — Fri, 02 Jun 2017 07:08:54 GMT

Hello, thanks

I have lots and lots of LOAD statements, I assume that I need to put it in every LOAD block?

Regards

Re: Data reload - testing script/presentation changes

MichalK — Fri, 02 Jun 2017 07:09:22 GMT

Hello, thanks.

That's what I've done today, copied app file to my desktop.

I also changed it to use no compression but full reload takes same amount of time, because source files that contains data extracted from sap are compressed too, I guess

Re: Data reload - testing script/presentation changes

felipedl — Mon, 05 Jun 2017 11:24:55 GMT

Hi Michal,

Depends from where your loading it.

If your loading from multiple files yes, if a single table holds all the data and then you derive the other tables from this one (Resident load) you can only do one.

I guess the fastest way to do it is simply do a find / replace of "load" to "first X load", where x is how many rows you want, something like:

table:

Load

From / Resident and so on.

to:

table:

first X load

From / Resident and so on.

Felipe.

Re: Data reload - testing script/presentation changes

MichalK — Mon, 05 Jun 2017 11:26:38 GMT

Thanks

this x can of course be variable too

Rgds