Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis, Quarter over Quarter comparison

Hi Guys,

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

Quarter over Quarter.png

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

result.png

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

Thanks in advance,

2 Replies
Gysbert_Wassenaar

You could try above(Orders)

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


talk is cheap, supply exceeds demand
Not applicable
Author

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.