Hi,
I've been playing with the Trellis extension in Qlik Sense September 2020 P2 and couldn't make it work in advanced mod
My formula for the KPI I've used in it is like this:
RangeSum( $(fRealized($1,$2)) , $(fPending($1,$2)) , $(fBonus($1,$2)) , $(fCashDiscount($1,$2)) , $(fForeignExch($1,$2)) )
where $1 is a parameter used to insert DISTINCT, TOTAL keywords and $2 is a parameter to change set analysis in the formulas, as an example:
"fPending" is defined as Sum( {<$(=Replace('$2',';',',')),Date_Type={'Statistic Date'}>} $1 [ANL_SALES.ORD_PEND_AMT_GROSS_EUR] )
I can't seem to find the right way to pass either $(vDim), $(vDimValue) or $(vDimSet) in the formulas.
Even simplifying down the formula doesn't seem to yield a correct solution.
Any suggestions?