topic Re: Set Analysis, Quarter over Quarter comparison in QlikView

Set Analysis, Quarter over Quarter comparison

Sun, 07 Oct 2012 04:26:18 GMT

Hi Guys,

I'm currenty trying to do a quarter over quarter order volume comparison. (see image below)

The Orders column is a count of all distinct orders for a paticular quarter. I'm having a hard time getting the "Last Quarter" Column to work however.

Ideally the "Last Quarter" column should display order volume for the last quarter.

i.e

I'm really stump so any help would be greatly appriciated.

Thanks in advance,

Re: Set Analysis, Quarter over Quarter comparison

Gysbert_Wassenaar — Sun, 07 Oct 2012 12:31:03 GMT

You could try above(Orders)

or maybe you can use this solution: http://qlikviewnotes.blogspot.com/2012/01/easy-period-analysis-using-qlikview.html

Re: Set Analysis, Quarter over Quarter comparison

Sun, 07 Oct 2012 14:59:21 GMT

I'm not quite sure how above(orders) would be applicable here, can you elaborate?

Alot of my problems seem to stem from using Quarter as a dimension in the straight table.