Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Hi Allan,
You can get idea from the below link.
http://community.qlik.com/message/253866#253866
Regrads,
Tom
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
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)