topic Re: complex if statement with interval - qlik sense in App Development

complex if statement with interval - qlik sense

joeybird — Tue, 19 Apr 2016 09:00:53 GMT

Hiya

I am trying a complex expression with a if statement with interval.

I have a person who records room temperature at different intervals of the day.

i have an expression

interval(min({<Temp={'40'}>} ObserveDateTime) - min({<Temp={'>40'}>} ObserveDateTime) ,'h:mm' )

this records how long it takes for a room to reach 40 in temperature

usally from observe number 1 to the observation number when temperature has been met. e.g 1 - 5

recorded by ObserveNumber 1, 2, 3 ect

This above works fine however, sometimes a recording has been done before opening time

i wish to create an if statement like

sum(if(min(ObserveDateTime) < OpeningDateTime , then start from ObserveNumber 2 instead of number 1

please help

Re: complex if statement with interval - qlik sense

swuehl — Tue, 19 Apr 2016 09:07:04 GMT

Maybe something like

interval(min({<Temp={'40'}>} ObserveDateTime) - min({<Temp={'>40'}, ObserveDateTime = {"=ObserveDateTime>=OpeningDateTime"}>} ObserveDateTime) ,'h:mm' )

edit: It would be easier to help you if you describe your data model and data a bit more in detail.

Maybe by posting some sample lines of data, e.g. as INLINE tables.

Or by posting a small sample app.

Re: complex if statement with interval - qlik sense

joeybird — Tue, 19 Apr 2016 09:31:01 GMT

does not seem to work correctly ...please help

Re: complex if statement with interval - qlik sense

swuehl — Tue, 19 Apr 2016 09:43:31 GMT

It would be easier to help you if you could describe your data model and data a bit more in detail.

We need to know how all the involved fields are related, for example ObserveDateTime and OpeningDateTime.

Maybe by posting some sample lines of data, e.g. as INLINE tables.

Or by posting a small sample app.

Re: complex if statement with interval - qlik sense

Tue, 19 Apr 2016 09:56:09 GMT

Perhaps:

interval(max({<Temp={'40'}>} ObserveDateTime) - min({<Temp={'>40'}>} IF(ObserveDateTime > OpeningDateTime,ObserveDateTime)) ,'h:mm' )