Discussion Board for collaboration on Server-Side Extensions and Advanced Analytics Integration.
as my first post ever on the Qlik Community, I was wondering whether and how set modifiers (as well as the "total" qualifier) can be used in conjunction with the AAI formulas (e.g. R.ScriptAggr).
Image, for instance, a barchart using [Field 1] as a dimension and a measure where this dimension needs to be ignored - e.g. to display a % of total:
sum([Field X]) / sum([Field X] total <[Field 1]>)
The numerator and denominator are hence essentially the same, only that the latter ignores the barchart's dimension. The equivalent of the numerator, using AAI, would be something like:
'sum(q$FieldX, na.rm = TRUE);'
,num("Field X") as FieldX
However, how could one specify the 'total' in the R.Scriptxxx formulas? Or is it simply not possible (yet), and if so, can we expect such feature in the future?