Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
francesco_menin
Partner - Creator III
Partner - Creator III

Qlik Sense Trellis extension: Advanced mode issues

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?

 

Labels (4)
0 Replies