topic Set Analysis - Sum on the opposite dimension in QlikView

Set Analysis - Sum on the opposite dimension

Anonymous — Tue, 09 Aug 2011 14:32:23 GMT

I have items in categories that are either "included" or "excluded". I need to create a straight table that lists the excluded items, but the calculation involves summing only the included items for that category. (it involves some weighting of the actual price based on included items).So my problem is how to create a set analysis expression that sums included items while displaying only the excluded items.

I am really just looking for the correct set analysis concept that will accomplish this idea.

Thoughts?

Set Analysis - Sum on the opposite dimension

ToniKautto — Tue, 09 Aug 2011 14:37:31 GMT

Not really clear on what you are trying to do. Please provide a sample QVW and describe what values you expect to se in your application object.

Re: Set Analysis - Sum on the opposite dimension

Anonymous — Tue, 09 Aug 2011 14:55:40 GMT

Here is a very simple example in Excel to demonstrate the concept. Note I have a data sheet and then a result sheet.

Re: Set Analysis - Sum on the opposite dimension

Anonymous — Tue, 09 Aug 2011 18:27:29 GMT

The solution I found was to join the data for the included items back into the model by the aggregation point which was Category in this example. I do not think it is possible to do this solely with set analysis. QVW is attached for reference.