Set analysis in AAI formulas

Anonymous — Sat, 16 Nov 2024 07:47:31 GMT

Hi community,

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:

R.ScriptAggrEx( 'N',

'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?

topic Set analysis in AAI formulas in Integration, Extension & APIs

Set analysis in AAI formulas