Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Limit of signs/characters in formulas/measures

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Limit of signs/characters in formulas/measures

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 Replies
Employee
Employee

Re: Limit of signs/characters in formulas/measures

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.

Not applicable

Re: Limit of signs/characters in formulas/measures

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.

Employee
Employee

Re: Limit of signs/characters in formulas/measures

I do believe they do.

Regards,

Patrik.

Community Browser