Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
MichalK
Contributor III
Contributor III

Data reload - testing script/presentation changes

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ł

1 Solution

Accepted Solutions
felipedl
Partner
Partner

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.ht...

Something like:

First 100

Load:

     A,

     B

From '(file)';

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

Felipe.

View solution in original post

6 Replies
felipedl
Partner
Partner

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.ht...

Something like:

First 100

Load:

     A,

     B

From '(file)';

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

Felipe.

View solution in original post

neelamsaroha157
Specialist II
Specialist II

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.

MichalK
Contributor III
Contributor III
Author

Hello, thanks

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


Regards

M

MichalK
Contributor III
Contributor III
Author

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

felipedl
Partner
Partner

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.

MichalK
Contributor III
Contributor III
Author

Thanks

this x can of course be variable too

Rgds

M