Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help to display 90 days record

Hi,

I am trying put a chart to display no name create in the last 90 days by title.

here is my ruff data:

Title Name Create Date
A AB 15/03/2012
A VA 02/02/2011
A EA 01/02/2012
A DF 07/03/2012
B ER 15/03/2012
B BF 02/02/2011
B QW 01/02/2012
B WE 07/03/2012
C ET 15/03/2012
C TY 02/02/2011
C YU 01/02/2012
D IU 15/10/2011
E AZ 29/11/2011
I AX 27/02/2012
I AC 19/08/2011
J AF 15/02/2012
K GH 02/02/2012

the result may come below

Title  Count

D        1

E        1

I          1

Can some one please advise what expression should work to display no name in last 90 days by title?

Thanks,

Dinesh

1 Reply
Not applicable
Author

Maybe something like

sum(aggr(if(max(Create Date)<today()-90,1),Title))

Might need some tweaking to get the desired result but that should help point you in the right direction.