Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
aaroncouran
Creator III
Creator 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?

1 Solution

Accepted Solutions
aaroncouran
Creator III
Creator III
Author

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.

View solution in original post

3 Replies
ToniKautto
Employee
Employee

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
Creator III
Creator III
Author

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

aaroncouran
Creator III
Creator III
Author

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.

View solution in original post