aggregation issue in cyclic group

Anonymous — Wed, 21 Aug 2013 07:52:55 GMT

Dear QV community

I am suppressing certain transactions based on the following criteria:

Material View (works fine)

Price 2011: only show Material Price for 2011 if Material has Price in 2011 and 2012

Price 2012: only show Material Price for 2012 if Material has Price in 2011 and 2012

Quantity 2011 only show Material Quantity for 2011 if Material has Price in 2011 and 2012

Quantity 2012 only show Material Quantity for 2012 if Material has Price in 2011 and 2012

Customer View (this is where the problem is)

Price 2011: only show Material Price for 2011 if Customer has purchased the same Material has Price in 2011 and 2012

Price 2012: only show Material Price for 2012 if Customer has purchased the same Material has Price in 2011 and 2012

Quantity 2011 only show Material Quantity for 2011 if Customer has purchased the same Material has Price in 2011 and 2012

Quantity 2012 only show Material Quantity for 2012 if Customer has purchased the same Material has Price in 2011 and 2012

Therefore the aggregation in the customer view should be based on customer and material, as it only makes sense to compare customers who have purchased the same material in both years.

This works well if you look at my example in step 1 for Price only.

However, I am having difficulties to apply the correct formula when in the customer view for quantities, while trying to check if there is a Price.

I have attached all the detailed steps to clarify what I really need and where my problem starts.

Your help is greatly appreciated,

Marco

topic aggregation issue in cyclic group in QlikView

aggregation issue in cyclic group