Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ribeiro
Specialist
Specialist

Add two conditions in the same column

Eu tenho essas duas condições.

Eles são para o mesmo campo.

get separada que funciona 100%

Mas eu não posso uni-los.

Eu estou fazendo duas guias para condições distintas.

1 = IF (Only ({<[GERENTE] = { 'GER. LJS DINAMIKA'}>} DESC_MAXIMO_CLI),

Apenas ({<[GERENTE] = { 'GER. LJS DINAMIKA'}>} DESC_MAXIMO_CLI), Only ({<[GERENTE] = { 'GER. LJ Fabr. DK'}>} DESC_MAXIMO_FIXO))

2 = if (sum (VLR_ITEM_FATURAR_TOTAL)> DESCONTO_MINIMO, DESCONTO_MAXIMO,

  if (sum (VLR_ITEM_FATURAR_TOTAL) <= DESCONTO_MINIMO, 'VALOR INFERIOR AO PEDIDO',

  se (ÉNulo (DESCONTO_PRAZO) OU LEN (TRIM (DESCONTO_PRAZO)) = 0, DESCONTO_MAXIMO, DESCONTO_PRAZO)))

Neves
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Can you describe the combined conditions in words please?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

7 Replies
vinieme12
Champion III
Champion III

Your first IF () expression doesn't have a condition to validate!

If ( condition,  is true, is false )

Anyways, how are you trying to merge them?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Ribeiro
Specialist
Specialist
Author

Would you have any suggestions,

2017-04-08_16-33-59.png

Neves
Ribeiro
Specialist
Specialist
Author

Number 1 and Number 2: Brings a discount result.

I need to create a joining condition in number 1

I have no idea how to do it ...

Neves
vinieme12
Champion III
Champion III

Can you describe the combined conditions in words please?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Ribeiro
Specialist
Specialist
Author

=If(Only({<[GERENTE]={'GER. LJS DINAMIKA'}>} DESC_MAXIMO_CLI), DESC_MAXIMO_CLI,

If(Only({<[GERENTE]={'GER. LJ FABR. DK'}>} DESC_MAXIMO_FIXO),DESC_MAXIMO_FIXO,

If(Only({<[GERENTE]={'GER. LJ FABR. RIMO'}>} DESC_MAXIMO_FIXO),DESC_MAXIMO_FIXO,

if(sum(VLR_ITEM_FATURAR_TOTAL) > DESCONTO_MINIMO,DESCONTO_MAXIMO,

if(sum(VLR_ITEM_FATURAR_TOTAL) <= DESCONTO_MINIMO,'VALOR INFERIOR AO PEDIDO',

if(IsNull(DESCONTO_PRAZO) OR LEN(TRIM(DESCONTO_PRAZO)) = 0, DESCONTO_MAXIMO,DESCONTO_PRAZO))))))

Neves
vinieme12
Champion III
Champion III

I think it should be like below

If(GERENTE='GER. LJS DINAMIKA',DESC_MAXIMO_CLI,

If(GERENTE]='GER. LJ FABR. DK',DESC_MAXIMO_FIXO,

if(sum(VLR_ITEM_FATURAR_TOTAL) > DESCONTO_MINIMO,DESCONTO_MAXIMO,

if(sum(VLR_ITEM_FATURAR_TOTAL) <= DESCONTO_MINIMO,'VALOR INFERIOR AO PEDIDO',

if(IsNull(DESCONTO_PRAZO) OR LEN(TRIM(DESCONTO_PRAZO)) = 0, DESCONTO_MAXIMO,DESCONTO_PRAZO))))))

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

If you can provide in statement the condition you are trying to evaluate or using a row of sample data, it'll be easier to assist

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.