topic time in QlikView

time

master_student — Fri, 04 Nov 2016 11:33:39 GMT

Hello community,

I need you for two things :

first, I would like to count person_ID if time (DATE_DEB) = '00:00:00' / I did like this but it didn' work : count (if (time (DATE_DEB)) ='00:00:00'))

the DATE_DEB field is like DD/MM/YYYY hh:mm:ss

second, I want to highlight in red the all record (in the table) when time (DATE_DEB) = '00:00:00'

Thank you very much

Re: time

fvelascog72 — Fri, 04 Nov 2016 12:34:49 GMT

Hi,

Take a look to the attached file.

Saludos.

Re: time

maxgro — Fri, 04 Nov 2016 12:51:46 GMT

you can check the time part of your field with frac function

frac(DATE_DEB)=0

Re: time

master_student — Fri, 04 Nov 2016 13:27:13 GMT

Thank you all and for the second question to get the record in red please.

Thanks

Re: time

master_student — Fri, 04 Nov 2016 13:27:44 GMT

Thank you Federico and how to get the record in red please.

Re: time

fvelascog72 — Fri, 04 Nov 2016 13:30:04 GMT

In the file you can see how to do it.

You can set background color in dimension properties.

Saludos.