Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bjdouglas
Contributor II
Contributor II

Is there a way to shutoff logging temporally within a script

I have an Autogenerate statement within my script:

Iteration:
Let x = ($(vCurYr) - 1996) * 12 + $(vCurMoNum) ;

for y = 1 to $(x)

for z = 1 to $(y)

// trace y=$(y) z=$(z);

load $(y) as Gen_Months, $(z) as Iteration

AutoGenerate 1;

next z

next y

This is what I see in the log

20231105T064900.917-0500 0116 for z = 1 to 23
20231105T064900.917-0500 0121 load 23 as Gen_Months, 1 as Iteration
20231105T064900.917-0500 0122
20231105T064900.917-0500 0123 AutoGenerate 1
20231105T064900.917-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.917-0500 254 lines fetched
20231105T064900.918-0500 0125 next z
20231105T064900.918-0500 0121 load 23 as Gen_Months, 2 as Iteration
20231105T064900.918-0500 0122
20231105T064900.918-0500 0123 AutoGenerate 1
20231105T064900.918-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.918-0500 255 lines fetched
20231105T064900.918-0500 0125 next z
20231105T064900.919-0500 0121 load 23 as Gen_Months, 3 as Iteration
20231105T064900.919-0500 0122
20231105T064900.919-0500 0123 AutoGenerate 1
20231105T064900.919-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.919-0500 256 lines fetched
20231105T064900.919-0500 0125 next z
20231105T064900.919-0500 0121 load 23 as Gen_Months, 4 as Iteration
20231105T064900.919-0500 0122
20231105T064900.919-0500 0123 AutoGenerate 1
20231105T064900.920-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.920-0500 257 lines fetched
20231105T064900.920-0500 0125 next z
20231105T064900.920-0500 0121 load 23 as Gen_Months, 5 as Iteration
20231105T064900.920-0500 0122
20231105T064900.920-0500 0123 AutoGenerate 1
20231105T064900.920-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.921-0500 258 lines fetched
20231105T064900.921-0500 0125 next z
20231105T064900.921-0500 0121 load 23 as Gen_Months, 6 as Iteration
20231105T064900.921-0500 0122
20231105T064900.921-0500 0123 AutoGenerate 1
20231105T064900.921-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.921-0500 259 lines fetched
20231105T064900.922-0500 0125 next z
20231105T064900.922-0500 0121 load 23 as Gen_Months, 7 as Iteration
20231105T064900.922-0500 0122
20231105T064900.922-0500 0123 AutoGenerate 1
20231105T064900.922-0500 2 fields found: Gen_Months, Iteration,
20231105T064900.922-0500 260 lines fetched

This goes on for 54K + lines fetched.

I'd like to temporarily shut logging off for this step.

Any ideas?

Labels (1)
1 Solution

Accepted Solutions
cwolf
Creator III
Creator III

a better way:

Let x = ($(vCurYr) - 1996) * 12 + $(vCurMoNum) ;

t:
load
Gen_Months,
IterNo() as Iteration
While IterNo()<=Gen_Months; 
Load
RecNo() as Gen_Months
AutoGenerate $(x);

View solution in original post

2 Replies
cwolf
Creator III
Creator III

a better way:

Let x = ($(vCurYr) - 1996) * 12 + $(vCurMoNum) ;

t:
load
Gen_Months,
IterNo() as Iteration
While IterNo()<=Gen_Months; 
Load
RecNo() as Gen_Months
AutoGenerate $(x);
bjdouglas
Contributor II
Contributor II
Author

Thank you! This works for what I wanted it to do. A lot fewer lines in the log. I suppose that you can't turn the log off temporarily.