topic Re. :Keep expression in 'Edit script' in QlikView

Keep expression in 'Edit script'

Tue, 01 Dec 2009 18:23:03 GMT

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.

Re. :Keep expression in 'Edit script'

Tue, 25 May 2010 10:19:54 GMT

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

Keep expression in 'Edit script'

andy — Mon, 04 Jul 2011 12:25:24 GMT

Answered here:

http://community.qlik.com/message/5981#5981