3 Replies Latest reply: Oct 17, 2012 8:23 AM by Allan McLuckie

# Calculating month on month growth using set analysis in a strait table

Hi Guys

I need some help calculating the month on month growth of our visits.

The attached excel sheet is what I would like my results to look like.

I can’t seem to get the month on month comparisons when using set analysis and a strait table chart type

I’m new to QV and any help would be appreciated

Many thanks

Allan

• ###### Re: Calculating month on month growth using set analysis in a strait table

Hi Allan,

You can get idea from the below link.

http://community.qlik.com/message/253866#253866

Tom

• ###### Re: Calculating month on month growth using set analysis in a strait table

Hi Tom

thansk for the response...

This example uses max function but i want to use a be repeated for each previous month and not just comparing the Max and its previous months

any other ideas?

thanks

Allan

• ###### Re: Calculating month on month growth using set analysis in a strait table

Someone at work managed to help me get this sorted

So for anyone who is interested?

This worked for last months growth

=Above(sum( {\$<[Fiscal Year] = {\$(=Only([Fiscal Year]))}, MetricType={'Visits'}>} Metric ),1)