topic Re: Set Analysis with Measures: multiple dimensions in App Development

Set Analysis with Measures: Multiple Nested Dimensions

zieben46 — Sat, 24 Dec 2022 12:58:34 GMT

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!

Re: Set Analysis with Measures: multiple dimensions

rubenmarin — Sat, 24 Dec 2022 11:29:43 GMT

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

Re: Set Analysis with Measures: multiple dimensions

zieben46 — Sat, 24 Dec 2022 12:56:55 GMT

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).

Re: Set Analysis with Measures: multiple dimensions

rubenmarin — Mon, 26 Dec 2022 15:37:49 GMT

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))

Re: Set Analysis with Measures: multiple dimensions

zieben46 — Mon, 26 Dec 2022 22:15:55 GMT

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!