Interval between two dates with set expression

[surtex]

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

[rwunderlich · Accepted solution]

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

-Rob

[LRuCelver · Accepted solution]

Try this:

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

[surtex]

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...

[surtex]

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

[surtex]

Does this function works with AVG too?

[LRuCelver]

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