Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
Not applicable
Author

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)

View solution in original post

3 Replies
thomas_skariah
Creator III
Creator III

Hi Allan,

You can get idea from the below link.

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

Regrads,

Tom

Not applicable
Author

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

Not applicable
Author

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)