topic Expression with set analysis in QlikView

Expression with set analysis

Tue, 31 Aug 2010 16:33:17 GMT

Hi,

how do I write this expression with set analysis?

count(if(right([OP - start],5)>'07:14' and right([OP - start],5)<='08:35' and (Group='COP') and Ydate=year(today()) and (Mdate=month(today())-1),1))

Best regards
Krister

Expression with set analysis

Miguel_Angel_Baeyens — Tue, 31 Aug 2010 16:58:55 GMT

Hello Krister and welcome to the forums,

Although you may be interested in using timestamp() or date() functions to extract time and date from your timestamp fields, your request should be something like

Count({< [OP - start] = {"=Right([OP - start], 5) > '07:14'", "=Right([OP - start], 5) <= '08:35'"}, Group = {'COP'}, Ydate = {'$(=Year(Today()))'}, Mdate = {'$(=Month(Today()) -1)'} >} 1)

This is untested, so please check that parentheses and brackets are properly closed.

Regards.

Expression with set analysis

Thu, 02 Sep 2010 10:21:00 GMT

Thanks for your qick respons, I got it to work using your expression.

Best regards
Krister