limitation in characters in expression

[RishabhTFC]

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

[rubenmarin]

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),...

[thakkarrahul01]

Interesting, could you figure out what is the limit?

[undergrinder]

Hi Rahul,

According to Javier response in this thread, the limit of expression is 8.192 characters

Re: Long text in Qlik Sense

ps.:I did'nt find this information on help site.

G.

[RishabhTFC]

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

[rubenmarin]

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)

[Patric_Nordstrom]

Fyi, the expression length has been increased from 8192 chrs to 64,000 chrs as of QS April 2019.

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Introduction/guidelines-...