topic InQuarter or what? in QlikView

InQuarter or what?

Fri, 08 Jan 2016 17:25:31 GMT

Hi everybody

I wanna have a SUM(Money) in the actual quarter in the actual year like quarter to date

how can i do that?

Thanks,

Cheers!

Re: InQuarter or what?

maxgro — Fri, 08 Jan 2016 21:36:32 GMT

maybe with some flags (IsInQTD, IsInYTD) in the calendar as explained here

Year-over-Year Comparisons

Re: InQuarter or what?

sunny_talwar — Fri, 08 Jan 2016 22:37:38 GMT

‌Flags are usually the best option because it makes the application so much more efficient. But in case you cannot change the script or you are looking for an alternative solution, you can try this:

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