topic Re: Current and previous month's report count in QlikView

Current and previous month's report count

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

hello,

I am trying to get count of reports for current month and previous month.

My month is getting calculated from master calender as

Date(MonthStart(Date),'MMM-YY') as Month

now I am writing two variables as

vCurrentMonthCount=count({<Month={"$(=max(Month))"}>}ReportName)
vPreviousMonthCount=count({<Month={"$(=max(Month)-1)"}>}ReportName)

But the previous month calculation is not giving me value. I am not sure
where is my mistake .

Please help.

arvind_patil — Thu, 27 Jul 2017 07:34:36 GMT

Hi Ashis,

Please try Below Expression:

vPreviousMonthCount=count({<Month={'$(=addmonths(max(Month)),-1)'}>}ReportName)

Thanks,

Arvind Patil

ashis — Thu, 27 Jul 2017 07:38:29 GMT

Thank for the reply, however it is giving me 0 value.

If I am correct addmonths will give the first date of the previous month. eg 1/6/2017 .

Regards,

Ashis

devarasu07 — Thu, 27 Jul 2017 08:00:46 GMT

Hi,

Can you try like this,

vPrevMonth

=count({<Month={'$(=Month(AddMonths(Today(),-1))'}>}ReportName)

Thanks,Deva

tresB — Thu, 27 Jul 2017 08:05:41 GMT

May be like:

vCurrentMonthCount=count({<Month={"$(=Date(max(Month),'MMM-YY'))"}>}ReportName)

vPreviousMonthCount=count({<Month={"$(=Date(AddMonths(max(Month),-1)),'MMM-YY')"}>}ReportName)

ashis — Thu, 27 Jul 2017 08:10:34 GMT

Thank you for your reply.

PreviousMonthCount is giving 0 value. However current month is fine.

Regards,

Ashis

tresB — Thu, 27 Jul 2017 08:47:28 GMT

A bit correction in brackets is needed.

vPreviousMonthCount=count({<Month={"$(=Date(AddMonths(max(Month),-1),'MMM-YY'))"}>}ReportName)

ashis — Thu, 27 Jul 2017 09:13:33 GMT

Thank you, this works.