Filtering KPI

[Beginner]

Hi,

I have a KPI I want to include, but I want my answer to be filtered to only include dates >90 days. What sort of expression would achieve this?

The data pulled for the KPI is all dates in the format 09 May 2017, if that help.

Thanks!

[sunny_talwar]

May be something like this

Sum({<Date = {"$(='>' & Date(Today()-90, 'DD MMM YYYY'))"}>}Measure)

[Beginner]

I have added this to the Expression, but it says 0 when it should be 5.

Do I edit this in anyway? aka the DD MM YYYY at all?

[sunny_talwar]

You mentioned that your date is formatted as 09 May 2017, right or is it 09/05/2017? or 09 05 2017? or something else.... you might need to modify the date format based on how your data field looks like.

[sunny_talwar]

Also, look here

Dates in Set Analysis

[Beginner]

I've created a test now to show you.

I have put this expression down: 

Sum({<Date={"$(='>'&Date(Today()-90,'DD/MM/YYYY'))"}>}Creation Date)

And my data inputted looks like the attached. And in my KPI is gives a dash.

[sunny_talwar · Accepted solution]

You want to Sum your creation Date? What do you get by summing a date field? Anyways, you might need to use Creation Date in your set analysis also

Sum({<[Creation Date] = {"$(='>'&Date(Today()-90,'DD/MM/YYYY'))"}>} [Creation Date])

[Beginner · Accepted solution]

Sorry no it should be count.  This works now:

Count({<[Creation Date] = {"$(='>'&Date(Today()-90,'DD/MM/YYYY'))"}>} [Creation Date])

 Thank you!

(p.s. I have another post in regards to both stacked and group charts into one in Qlik Sense 🙂 )

Stacked and Grouped Chart in One?

[Beginner]

Hi also one last one which is very similar.

I have a column that is Days at Current Status, see the attached excel.

How do I filter this as well for ones greater than 90 days, counting the number of occurrences under Days at Current Status.

[sunny_talwar]

I am not sure I follow? You want to filter one greater than 90 days? What does one greater means?