topic Re: Help Please~How to Calculate Monthly Total in Set Analysis? in QlikView

Help Please~How to Calculate Monthly Total in Set Analysis?

Wed, 17 Feb 2016 01:27:31 GMT

Hi Experts,

Thanks for taking time to look at my question.

I was asked to calculate the monthly total quotes(for insurance) based on different areas.

First. I was trying to calculate the MTD (Month to Date) total quotes by using the expression as follow, I think it works.

=sum({<Month = {$(=Month(Today()))}, Year = {$(=Year(Today()))},QuoteDate=>}QuoteCount)

Then, I want to calculate the total quotes for previous two months separately(dynamic month): Dec( from Dec.1.2015--Dec.31.2015) and last year Novemer,but I don't know how to do it. The data structure is as follow picture:

Can anybody help me with it? Thank you so much.

Re: Help Please~How to Calculate Monthly Total in Set Analysis?

sunny_talwar — Thu, 18 Feb 2016 10:50:10 GMT

Would you be able to share some data with your expected output? Difficult to understand the requirement without looking at an expected output

Re: Help Please~How to Calculate Monthly Total in Set Analysis?

luciancotea — Thu, 18 Feb 2016 14:42:34 GMT

Dec =sum({<Month = {$(=Month(addmonths(Today(), -1)))}, Year = {$(=Year(addmonths(Today(), -1)))},QuoteDate=>}QuoteCount)

Nov =sum({<Month = {$(=Month(addmonths(Today(), -2)))}, Year = {$(=Year(addmonths(Today(), -2)))},QuoteDate=>}QuoteCount)