topic Re: Quarter to till date in QlikView

Quarter to till date

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How to get a sum from current quarter to till date.

Can you guide me on this.

Regards,

Kumar

Re: Quarter to till date

sunny_talwar — Thu, 07 Apr 2016 12:55:51 GMT

May be using your date field:

Sum({<Date = {"$(='>=' & Date(QuarterStart(Max(Date)), 'YourDateFieldFormatHere') & '<=' & Date(Max(Date), 'YourDateFieldFormatHere'))"}, Quarter, Year, Month, Date, Day>} Sales)

Re: Quarter to till date

Anonymous — Thu, 07 Apr 2016 13:01:21 GMT

Thanks Sunny. In expression is it require Quarter, Year, Month, Date, Day irrespective of YTD,MTD and QTD.

Re: Quarter to till date

sunny_talwar — Thu, 07 Apr 2016 13:03:13 GMT

Those are there so that selection in these fields doesn't impact the expression. Everything should be driven based on DateField.