COUNT and MIN functions

Thu, 25 Oct 2012 11:36:43 GMT

Hi,

I'm receiving an error when using the COUNT and MIN functions within an IF Statment in my script.

Am I allowed do this or is there another reason for the error?

Thanks

LEFT JOIN (TEST)
LOAD Delivery_VBELN.LIKP as [Delivery Docket],

if(count([Pick Date_KODAT.LIKP]) > 1, min(date([Pick Date_KODAT.LIKP],'YYYY-MM-DD')), date([Pick Date_KODAT.LIKP],'YYYY-MM-DD')) as [Picking date2]
FROM
D:\QlikViewReports\LIKP_header.QVD
(qvd)

GROUP BY Delivery_VBELN.LIKP

Re: COUNT and MIN functions

hic — Thu, 25 Oct 2012 12:12:32 GMT

The second parameter of the if function doesn't contain any aggregation function. It should. Most likely this causes the error.

HIC

topic COUNT and MIN functions in QlikView

COUNT and MIN functions

Re: COUNT and MIN functions