Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
dwfiv327
Contributor II
Contributor II

Finding minimum during load

I would like to find the minimum and maximum values of a field during the load process and store those values in variables.  Just putting LET vMin=Min(field); in the script doesn't work.  Any suggestions?

Daniel W. Farrow, IV

Business Systems Analyst

1 Solution

Accepted Solutions
sunny_talwar

Check the master calendar script where we calculate min and max of date to create the calendar

Creating A Master Calendar

Capture.PNG

Thing to note here is that you can't directly save min and max to a variable. You will have to do a resident load where you calculate min and max and then use Peek to save them in variable.

View solution in original post

2 Replies
sunny_talwar

Check the master calendar script where we calculate min and max of date to create the calendar

Creating A Master Calendar

Capture.PNG

Thing to note here is that you can't directly save min and max to a variable. You will have to do a resident load where you calculate min and max and then use Peek to save them in variable.

dwfiv327
Contributor II
Contributor II
Author

Thanks.  This worked perfectly!