Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Keep expression in 'Edit script'

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.

2 Replies
Not applicable
Author

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

andy
Partner - Creator III
Partner - Creator III