Help to display 90 days record

Thu, 15 Mar 2012 18:09:26 GMT

Hi,

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

here is my ruff data:

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

Thu, 15 Mar 2012 18:44:13 GMT

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.

topic Help to display 90 days record in QlikView