another Set analyses topic which can hopefully be solved in Qlik Sense with your help.
Here my pseudo code what I want to achive in a straight table with of course multiple dimensions.
Compare FieldA value with All(1 as set identifier) Field B values and Sum(sells) like Field A values Would be a selection for field B.
I have a working set analyses for a KPI which sums without dimension but I would like to make this calculation for every Field A value in table.
I know this sounds pretty abstract and dont seems to make sense but well, this ist just a really tiny discription of a pretty big Datamodel.
But the Topic summaries the issue.
Thanks for help.
SET evaluates once per chart , you cannot have a different set for each value
View solution in original post
Thanks for reply,
thought something like that. Hoped a combination of set and aggr would help.
Solved the problem in scripteditor.