topic Problem if work dates in QlikView https://community.qlik.com/t5/QlikView/Problem-if-work-dates/m-p/192430#M54087 <HTML><HEAD></HEAD><BODY><P>I need a personal assistance to work with a subtraction between two dates. I need the result that date when greater than 24 hours to appear as one days and zero hours. And goes like on. Here my query attached to the staff take a look at the first tab has several sections refer to stages of production, and within this stage has a maximum and minimum. We must show it in the format that I explained to you. Grateful.</P><P></P><P></P><P>max</P><P></P><P>(aggr(IF(CODIGO_ESTAGIO = 21, (([DATA_PROD]) - ([DATA_BAIXA]))*24),CODIGO_ESTAGIO,ORDEM_PRODUCAO))</P><BR /><BR /> <P></P><P>min</P><P></P><P>(aggr(IF(CODIGO_ESTAGIO = 21, (([DATA_PROD]) - ([DATA_BAIXA]))*24),CODIGO_ESTAGIO,ORDEM_PRODUCAO))</P><P></P><BR /><BR /></BODY></HTML> Thu, 17 Jun 2010 13:36:35 GMT 2010-06-17T13:36:35Z Problem if work dates https://community.qlik.com/t5/QlikView/Problem-if-work-dates/m-p/192430#M54087 <HTML><HEAD></HEAD><BODY><P>I need a personal assistance to work with a subtraction between two dates. I need the result that date when greater than 24 hours to appear as one days and zero hours. And goes like on. Here my query attached to the staff take a look at the first tab has several sections refer to stages of production, and within this stage has a maximum and minimum. We must show it in the format that I explained to you. Grateful.</P><P></P><P></P><P>max</P><P></P><P>(aggr(IF(CODIGO_ESTAGIO = 21, (([DATA_PROD]) - ([DATA_BAIXA]))*24),CODIGO_ESTAGIO,ORDEM_PRODUCAO))</P><BR /><BR /> <P></P><P>min</P><P></P><P>(aggr(IF(CODIGO_ESTAGIO = 21, (([DATA_PROD]) - ([DATA_BAIXA]))*24),CODIGO_ESTAGIO,ORDEM_PRODUCAO))</P><P></P><BR /><BR /></BODY></HTML> Thu, 17 Jun 2010 13:36:35 GMT https://community.qlik.com/t5/QlikView/Problem-if-work-dates/m-p/192430#M54087 2010-06-17T13:36:35Z