topic Prior Quarter Count Help in QlikView

Prior Quarter Count Help

Anonymous — Tue, 04 Aug 2015 19:42:55 GMT

Hi All,

I need help with an expression that can COUNT prior quarter items. Currently, i select a quarter date listbox where it will return a count status total for this quarter. At the same time, i want to have a count total for prior quarter.

For example:

Selected 12/31/2014

Returns a count of 100

Also, wants a return count of prior quarter (9/30/2014)

count([Status])

Any inputs will greatly appreciated!

Thanks,

Frank

Re: Prior Quarter Count Help

sunny_talwar — Tue, 04 Aug 2015 20:44:51 GMT

Try this in a text box may be:

=Count({<Date = {"$(='>=' & Date(QuarterStart(AddMonths(Max(Date), -3))) & '<=' & Date(QuarterEnd(AddMonths(Max(Date), -3))) )"}>} Status)

Re: Prior Quarter Count Help

Anonymous — Tue, 04 Aug 2015 21:06:40 GMT

Again.. Thank You Sunny!

Before I used this expression but not working..

=count({<Valuation_Quarter={"$(=date(quarterend(max(Valuation_Quarter),-1),'MM/DD/YYYY'))"}>} [Status])