Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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.
I do believe they do.
Regards,
Patrik.