topic Re: Interval between two dates with set expression in App Development

Interval between two dates with set expression

surtex — Tue, 12 Mar 2024 13:48:16 GMT

Hey Members,

i have the following problem:

I would like to calculate the differences (in days) between two dates witth set expression, like here:

SLA Statuswechsel with SLA Status 'Technical Complete' - SLA Statuswechsel with SLA Status 'Open'

Following necessary information:

SLA Statuswechsel = Date Field (includes the date in following format: DD.MM.YYYY)

SLA Status: Includes different Status (Open, In Progress, Technical Complete, Close).

Can anyone help me???

Thanks and regards

Josh

Re: Interval between two dates with set expression

rwunderlich — Tue, 12 Mar 2024 14:50:43 GMT

See https://community.qlik.com/t5/QlikView-App-Dev/Comparing-dates-in-the-same-field-in-QV/td-p/487878

-Rob

Re: Interval between two dates with set expression

LRuCelver — Tue, 12 Mar 2024 14:59:54 GMT

Try this:

fAbs(Only({<Status={'Technical Complete'}>} [SLA Statuswechsel]) - Only({<Status={'Open'}>} [SLA Statuswechsel]))

Re: Interval between two dates with set expression

surtex — Tue, 12 Mar 2024 15:00:17 GMT

Hey thanks but the solution doesn't work for me. I would like to use this formula in a KPI diagram where you can just use measures and not dimensions...

Re: Interval between two dates with set expression

surtex — Tue, 12 Mar 2024 15:11:42 GMT

Hey both solutions works in a table but not in a measure KPI field. Do you have any explanation?

Re: Interval between two dates with set expression

surtex — Tue, 12 Mar 2024 15:22:43 GMT

Does this function works with AVG too?

Re: Interval between two dates with set expression

LRuCelver — Tue, 12 Mar 2024 15:27:06 GMT

You can use most aggregation functions (min, max, sum, avg, ...) instead of Only().