Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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!