Set Analysis with Measures: Multiple Nested Dimensions

[zieben46]

Follow-up to this excellent video:

https://www.youtube.com/watch?v=wSrKGu_8EfU&ab_channel=Qlik

Sum({<[Model Variation]={"SUM(PartSales) >= 1000"}>} PartSales)

What if there were 2 dimensions, say Model Variation and Model Color, and looking for sum sales > 1000 for each model variation & model color combo?

Thanks!

[rubenmarin]

Hi, I think this would be easier if you create a field that merges model and color, so you can use this field in set analysis.

You can create the field as Model &'_'& Color as ModelColor

[zieben46]

Thanks, yes this works!

I'll be using this method for now, but I'm seeking a solution that is 100% front end (no creation of extra columns upon load). 

[rubenmarin · Accepted solution]

You can aggr to split a calculation in the differnt combinations of fields values,like:

Sum(Aggr(If(Sum(PartSales)>=1000, Sum(PartSales)),Model,Color))

[zieben46]

This works!  Nice & clean solution.  And my testing shows the outer SUM is not necessary. 

I was in a rabbit hole w/ set analysis (good to learn regardless).

Thank you sir!