topic Re: If Statement in QlikView

If Statement

qlikofba — Mon, 09 Nov 2015 18:42:26 GMT

The code below is not working correctly.

if(TRAN_CD <> 355 and (DFNR_CD = 0 and SUM_TRAN_AMT <> 100 and SUM_TRAN_AMT <> 50 and SUM_TRAN_AMT <> -100 and SUM_TRAN_AMT <> -50), SUM_TRAN_AMT,

if(TRAN_CD <> 355 and (DFNR_CD <> 5200 and DFNR_CD <> 52000 and DFNR_CD <> 25000 and DFNR_CD <> 50191), SUM_TRAN_AMT, 0)) as Charges

When the second if is commented out(see below the first conditional works, when it is uncommented it does not. Any ideas on why?

if(TRAN_CD <> 355 and (DFNR_CD = 0 and SUM_TRAN_AMT <> 100 and SUM_TRAN_AMT <> 50 and SUM_TRAN_AMT <> -100 and SUM_TRAN_AMT <> -50), SUM_TRAN_AMT, 0) as Charges

Re: If Statement

swuehl — Mon, 09 Nov 2015 19:38:37 GMT

What do you exactely mean with 'not working correctly'? Can you post some sample lines of input data and what you expect to see?

Re: If Statement

qlikofba — Mon, 09 Nov 2015 19:41:43 GMT

There are DFNR_CD of 0 that have SUM TRAN AMTS of 100 that are being displayed as a Charge of 100.

They should be displayed as 0

Re: If Statement

swuehl — Mon, 09 Nov 2015 20:21:31 GMT

What about the TRAN_CD of these records?

If TRAN_CD <> 355, wouldn't the second if() statement be valuated true?

Re: If Statement

qlikofba — Mon, 09 Nov 2015 20:27:51 GMT

The tran codes that are 355 should be displayed as 0s as well.

Re: If Statement

swuehl — Mon, 09 Nov 2015 20:46:04 GMT

What exactely is wrong with the result?

LOAD

if(TRAN_CD <> 355 and (DFNR_CD = 0 and SUM_TRAN_AMT <> 100 and SUM_TRAN_AMT <> 50 and SUM_TRAN_AMT <> -100 and SUM_TRAN_AMT <> -50), SUM_TRAN_AMT,

if(TRAN_CD <> 355 and (DFNR_CD <> 5200 and DFNR_CD <> 52000 and DFNR_CD <> 25000 and DFNR_CD <> 50191), SUM_TRAN_AMT, 0)) as Charges,

INLINE [

TRAN_CD, DFNR_CD, SUM_TRAN_AMT

0, 0,100

355,0,100

];