Qlik Sense Trellis extension: Advanced mode issues

francesco_menin — Sat, 16 Nov 2024 00:53:17 GMT

Hi,

I've been playing with the Trellis extension in 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?

topic Qlik Sense Trellis extension: Advanced mode issues in Integration, Extension & APIs

Qlik Sense Trellis extension: Advanced mode issues