Parallel Period compare and Cycle Period Compare

[#1]

Hi all,

Is there any method that can be used to calculate Parallel Period compare and Cycle Period Compare?

Thanks.

[mike_garcia]

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.

[#3]

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.