Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
Check the master calendar script where we calculate min and max of date to create the calendar
Creating A Master Calendar
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.
Thanks. This worked perfectly!