topic Re: Calculated expression? in QlikView

Calculated expression?

Anonymous — Wed, 22 Feb 2017 13:37:40 GMT

Hi,

I am trying to calculate a rest, but that only display open records but I am not being able to do it.

I am trying

Today()-[DaysSinceOpened]

But if I try to add the exclusion as

={$<Status -= 'Closed'>},Today()-[DaysSinceOpened]

it's not working, is there a way to make this work?

Anil_Babu_Samineni — Wed, 22 Feb 2017 13:42:37 GMT

I am assuming, You are doing set analysis with Interval. Is there any chance to share whole expression?

sunny_talwar — Wed, 22 Feb 2017 13:46:58 GMT

May be try this:

Only({$<Status -= 'Closed'>} Today() - DaysSinceOpened)

sunny_talwar — Wed, 22 Feb 2017 13:47:43 GMT

Or this:

If(Status <>'Closed', Today()) - Only({$<Status -= 'Closed'>} DaysSinceOpened)