Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Is there any method that can be used to calculate Parallel Period compare and Cycle Period Compare?
Thanks.
Hello Isaac!
You mean comparisons between two periods? For example Dec 2010 vs Dec 2009?
If so, you can do that with Set Analysis. I have a guide in my blog if you are new to the topic. http://iqlik.wordpress.com
Regards,
Mike.
Hi Mike,
Thanks for your marvellous articles:).
But I have another question, the set analysis expression is based on current max month or year. But I want to show the data in the table without user selection.
For example:
Year Month Amount Paralle Period Compare
2009 1 $30 -
2009 2 $40 -
2010 1 $60 100%
2010 2 $120 300%
Then how can I get current row's year and month to calculate the rate?
Thanks.