topic Parallel Period compare and Cycle Period Compare in QlikView

Parallel Period compare and Cycle Period Compare

Thu, 30 Dec 2010 07:41:37 GMT

Hi all,

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

Thanks.

Parallel Period compare and Cycle Period Compare

mike_garcia — Thu, 30 Dec 2010 22:10:50 GMT

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.

Parallel Period compare and Cycle Period Compare

Fri, 31 Dec 2010 04:22:22 GMT

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.