Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
robertocesp
Contributor II

Calculated expression?

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?

1 Solution

Accepted Solutions

Re: Calculated expression?

May be try this:

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

View solution in original post

3 Replies

Re: Calculated expression?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Calculated expression?

May be try this:

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

View solution in original post

Re: Calculated expression?

Or this:

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