Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aaroncouran
Contributor III

Set Analysis - Sum on the opposite dimension

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?

Tags (1)
1 Solution

Accepted Solutions
aaroncouran
Contributor III

Re: Set Analysis - Sum on the opposite dimension

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.

3 Replies
Employee
Employee

Set Analysis - Sum on the opposite dimension

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.

aaroncouran
Contributor III

Re: Set Analysis - Sum on the opposite dimension

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

aaroncouran
Contributor III

Re: Set Analysis - Sum on the opposite dimension

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.

Community Browser