Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reverse the input signal and Reversal (Inverter o Sinal de Entrada e Estorno)

I would put some releases as negative. with this rule is doing at all and not only with the 'C' claims.

IF (CXBDEC = 'C', VLRRAT, VLRRAT * -1) AS [BALANCE CASH]

Its somehow the transformer fix it?

Translated with Google Translate - Qlik Community Administrative Team

gostaria de colocar alguns lançamentos como negativos. com essa regra está fazendo em todos e não só com os créditos 'C'.

IF(CXBDEC = 'C', VLRRAT, VLRRAT *-1)              AS [SALDO CAIXA],

Tem como de alguma forma no transformador corrigir isso?

2 Replies

Re: Reverse the input signal and Reversal (Inverter o Sinal de Entrada e Estorno)

Please post sample data and expected result.

Regards

Marco

MVP
MVP

Re: Reverse the input signal and Reversal (Inverter o Sinal de Entrada e Estorno)

If( Index( 'CXBDEC' , CXBDEC) , -1 , 0 )

This will check if the field CXBDEC is equal to any of the letters C, X, B, D, E, C and return negative if so and return 0 if not.

Community Browser