Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
dwfiv327
New 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

Re: Finding minimum during load

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.

2 Replies

Re: Finding minimum during load

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
New Contributor II

Re: Finding minimum during load

Thanks.  This worked perfectly!