# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor

## Display aging based on specified date range.

How can I show aging in my KPI only for Id that have minimum Gate 0 date that equal or greater than 1 Jan 2018?

Based on below example, my KPI should show 5.

1 Solution

Accepted Solutions
MVP

## Re: Display aging based on specified date range.

May be something like this

=Num(Avg(ProjectID = {"=Max({<Gate = {'Gate 0'}>}Date) > MakeDate(2018, 1, 1)"}>} ([Modified]-[Created])),'##.0')

5 Replies
Valued Contributor

## Re: Display aging based on specified date range.

Try this expression

MinString({<Gate={Gate0},Date={">=1/1/2018"}>}Aging)

MVP

## Re: Display aging based on specified date range.

I am not sure I understand how you are getting Aging? Is that a column from your table? Also, can you may be re-explain the logic behind seeing only A111's aging?

Contributor

## Re: Display aging based on specified date range.

Hi Sunny,

Please refer below data. Basically, i want to exclude project that have minimum Gate 0 that less than 1 Jan 2018.

So based on below data, my KPI aging will show only for project A111 because A112 has minimum gate 0 less than 1 Jan 2018.

Current formula:

([Modified]-[Created])),'##.0')

MVP

## Re: Display aging based on specified date range.

May be something like this

=Num(Avg(ProjectID = {"=Max({<Gate = {'Gate 0'}>}Date) > MakeDate(2018, 1, 1)"}>} ([Modified]-[Created])),'##.0')

Contributor

## Re: Display aging based on specified date range.

Hi Sunny,

With a bit modification to suit my need. i manage to get what i want. Thanks.

Community Browser