Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem if work dates

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.

max

(aggr(IF(CODIGO_ESTAGIO = 21, (([DATA_PROD]) - ([DATA_BAIXA]))*24),CODIGO_ESTAGIO,ORDEM_PRODUCAO))



min

(aggr(IF(CODIGO_ESTAGIO = 21, (([DATA_PROD]) - ([DATA_BAIXA]))*24),CODIGO_ESTAGIO,ORDEM_PRODUCAO))



0 Replies