topic Rolling Month with maximum day in QlikView

Rolling Month with maximum day

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

Dear Team,

i stuck a requirement.

i am calculating rolling month 12. But i am want to calculate last 12 month of maximum day data.

Suppose we have data last month1 to 30.and i want to sum of sale only 30's day means max day of the month.Same last 12 month.How is it. Kindly help me.

Re: Rolling Month with maximum day

pathiqvd — Thu, 05 Jan 2017 07:46:52 GMT

Hi,

Try this may be you will get,

=Count({<date_field={">=$(=date(max(date_field)-360))<=$(=date(max(date_field)))"}>}DISTINCT Client_id)

Regards,

Re: Rolling Month with maximum day

panipat1990 — Thu, 05 Jan 2017 07:49:21 GMT

i want to calculate last Each month data's of maximum day.Like 30 and 31.

Re: Rolling Month with maximum day

sunny_talwar — Thu, 05 Jan 2017 10:31:25 GMT

May be like this:

=Count({<date_field={"=Day(date_field) = Day(MonthEnd(date_field))"}>} DISTINCT Client_id)