Limit of signs/characters in formulas/measures

[#1]

Hi there,

I have to two different complex formulas in two KPI´s, which give me two numbers and I want to substract the second of the first.

The Aggregation of both KPI´s is Count. Therefore I tried to made this:

Formula1- Formula2

But there seems to be a Limitation to the number of signs/characters you can use in one measure/formula.  I think so because, I can not copy and paste the second formula into the Measures of the first formula and both formulas have more than at least 1000 signs/characters (I did not count them all).

So my question is:

Is there a Limit of signs/chracters in formulas/measures ? Or what else could be the Problem?

By the way the first formula uses Set Analysis and the second one if-conditions and I am using Qlik Sense.

Thanks in advance and best regards

Thorqlik

[Patrik_Lundblad · Accepted solution]

Hi thorqlik,

The current limit is described at https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Introduction/guidelines-visualizations-... and we are looking at upping it for the future.

Expressions: Max 8,192 characters

Regards,

Patrik.

[#3]

thank you very much Patrik.

Do blanks/spaces also Count as characters ?

Otherwise I guess I have to rename some Fields to shorten the Expression.

[Patrik_Lundblad]

I do believe they do.

Regards,

Patrik.