Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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))
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
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).
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))
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!