Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello guys, I am facing a problem regarding characters limitation in the expression editor.
Actually, the problem is that the formula I am using in the expression editor does not paste full.
how can I use the full formula in the expression editor
Hi Shubham, so long expression maybe can be translated to short expression lenght, also you can use variables to store parts of expression:
SET varSum1 = Sum({long_set analysis} field);
Expression can be:
If($(varSum1)>$(varSum2),...
Interesting, could you figure out what is the limit?
Hi Rahul,
According to Javier response in this thread, the limit of expression is 8.192 characters
ps.:I did'nt find this information on help site.
G.
Hi Ruben,
I am tried to make a variable but I am unable to use it in expression it shows "-" value.
Lets For Example there is two variable var and var_1. The output I get by those are:
So, basically I want output like var variable. but when I insert my formula in script. It shows me error.
So can you help me to solve this.
Thanks
SG
Hi Shubham, you need to use as SET, to store the string of the expression, not the result
SET vDirectCosts = sum(..) + Sum(...) + Sum(...);
Expression:
=$(v311010)-$(vDirectCosts)...
Also, some Set analysis seems that can be grouped to reduce length:
Sum({<FieldA={"A"}, FieldB={"B"}> Value)+Sum({<FieldA={"A"}, FieldB={"C"}> Value)
Can Be:
Sum({<FieldA={"A"}, FieldB={"B","C"}> Value)
Fyi, the expression length has been increased from 8192 chrs to 64,000 chrs as of QS April 2019.