Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
Instavini
Contributor II
Contributor II

Função IF com mais de 100 linhas

Pessoal, boa tarde

 

estou usando a função if para classificar alguns tipos de depesas, porém chegou a 100 linhas e aparece o seguinte erro"Too Complex, more than 100 levels nesting 

 

segue a formula como estou usando:

if([CPA.nomeusual] ='EMPRESATESTE' and [CPA.CodEntCPR] = '99285' and [CPA.CodProd] = '00327', 'ALUGUEL',

e 99+ outras linhas dessa acima...

 

há alguma solução para passar por "cima" disso?

 

Labels (3)
1 Solution

Accepted Solutions
Bill_Britt
Support
Support

R&D advised to look at this article.

 

https://community.qlik.com/t5/Official-Support-Articles/Why-Is-It-Not-A-Good-Idea-To-Use-Nested-If-S...

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

View solution in original post

2 Replies
Bill_Britt
Support
Support

OI,
Entrei em contato com P&D para tentar encontrar uma resposta para você.

 

 

HI,
I have reached out to R&D to try to find an answer for you.

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Bill_Britt
Support
Support

R&D advised to look at this article.

 

https://community.qlik.com/t5/Official-Support-Articles/Why-Is-It-Not-A-Good-Idea-To-Use-Nested-If-S...

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.