topic Re: Count Previous Month in QlikView

Count Previous Month

Thu, 07 May 2015 08:59:20 GMT

Hi All,

I have an expression below to select data for the current month

count({<DateRaised={"=(MonthName(addmonths(today(),0))" },ValueID={'*24*'}, IncidentType={'*Accident*'}, ListTitle={'*Employee*'}>}ValueID)

I know the Month function works as I have used it on labels but for some reason I am getting no numbers back from the expression but it validates?

I have attached the qv file and the elements are on the sheet two tab. Any help would be greatly appreciated!

Toby

Re: Count Previous Month

sunny_talwar — Thu, 07 May 2015 09:07:47 GMT

Date raised is a timestamp field like this (DD/MM/YYYY hh:mm:ss) and you are comparing it to a MonthYear field. This won't work. You will get a result if you compare the same formats.

Re: Count Previous Month

Thu, 07 May 2015 09:13:22 GMT

Thanks sunindia

I did wondered if it might be a format issue. I have a DateraisedIMS formatted to dd/mm/yyyy, how do I then match it up?

Re: Count Previous Month

sunny_talwar — Thu, 07 May 2015 09:13:32 GMT

This formula should work:

=Count({<DateRaised={"=MonthName(DateRaised) = MonthName(addmonths(today(),-2))" },ValueID={'*24*'}, IncidentType={'*Accident*'}, ListTitle={'*Employee*'}>}ValueID)

Re: Count Previous Month

Thu, 07 May 2015 09:15:16 GMT

Fantastic, thank you Sunindia

Re: Count Previous Month

sunny_talwar — Thu, 07 May 2015 09:15:32 GMT

Please find attached your application. You will see 0 for May and Apr because there are no ValueID available for those period, but March has 4 ValueID

HTH

Best,

Sunny

Re: Count Previous Month

sunny_talwar — Thu, 07 May 2015 09:15:58 GMT

No Problem.