topic Set Analysis with date params in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-date-params/m-p/367480#M136652 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have an issue with using Min, Max and Only in sets.&nbsp; The following expression doesn't calculate the correct values: -</P><P></P><P>=Num(Sum(</P><P>{$&lt;DATA_QUALITY = {1}, ORDER_STATUS -= {'refund'}, TEST_ORDER = {0}, VALID_ORDER = {1}, ITEM_TYPE-={'delivery','offer','delivery_surcharge'}, $(=Num([First Order Date])) = {"&gt;=$(=Min(Standard_Date))&lt;=$(=Max(Standard_Date))"}&gt; } $(=Only(Prefix))_$(=Only(Suffix))),$(=Only(Format)))</P><P></P><P>Basically the objective of the above script is to Sum items where the "First Order Date" is between the selected "Calendar Start and End Dates"</P></BODY></HTML> Thu, 24 May 2012 13:00:45 GMT 2012-05-24T13:00:45Z Set Analysis with date params https://community.qlik.com/t5/QlikView/Set-Analysis-with-date-params/m-p/367480#M136652 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have an issue with using Min, Max and Only in sets.&nbsp; The following expression doesn't calculate the correct values: -</P><P></P><P>=Num(Sum(</P><P>{$&lt;DATA_QUALITY = {1}, ORDER_STATUS -= {'refund'}, TEST_ORDER = {0}, VALID_ORDER = {1}, ITEM_TYPE-={'delivery','offer','delivery_surcharge'}, $(=Num([First Order Date])) = {"&gt;=$(=Min(Standard_Date))&lt;=$(=Max(Standard_Date))"}&gt; } $(=Only(Prefix))_$(=Only(Suffix))),$(=Only(Format)))</P><P></P><P>Basically the objective of the above script is to Sum items where the "First Order Date" is between the selected "Calendar Start and End Dates"</P></BODY></HTML> Thu, 24 May 2012 13:00:45 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-date-params/m-p/367480#M136652 2012-05-24T13:00:45Z