Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to keep all expressions in 'Edit script' instead of write them in qlikview object like chart (for easily modify)
- example :
SET eQVobject = 'SUM(Amount)' ;
and use variable "eQVobject" in chart expression
But when I use set analysis in the expression like this below
- example :
SET ExSP1 = 'SUM({$<Year={$(=MAX(GI_Year)-1)},POSTING_DATE = {""<=$(=ADDMONTHS(MAX(POSTING_DATE),-12))""}>} SALES_AMOUNT)';
expression ExSP1 can not be applicable and when i looked it in expression overview, it shown :
SUM({$<GI.Year={(internal error)},POSTING_DATE = {""<=(internal error)""}>} SALES_AMOUNT)
Please help me to solve this problem.
// I'm ever to use inputbox to solve this problem but it's not flexible.
Any answer about this probleme for use variable ?
We have the same problem: impossible to retrieve and use a variable from chart expression with a Set Analysis
variable: vResultExclBunkerSwap12Months_nosynch
Function: LET vResultExclBunkerSwap12Months_nosynch = 'SUM({$<YearMonthCounter = {">$(=only(YearMonthCounterTest)-12)"},YearMonthCounter = {"<=$(=only(YearMonthCounterTest))"}, Month=>}RESULT)';
from a file: $(include=M:\SERVICES\SAFRAN\LMD\3-Development\Liste des formules-TEST.txt);
Regards,
Eric NERCAM
Answered here: