topic Re: Oralce Decode function in Qlikview chart expression??? in QlikView

Oralce Decode function in Qlikview chart expression???

Tue, 21 Jul 2015 16:15:37 GMT

I am not sure, how to write this in Qlikview chart expression.

SUM(DECODE(INDTRANS,'T',0, NUMCTNCM))

with the following conditions:

//" ( ACUMTEMP ) = 'MTH' )
// AND
// ( ( IDESCENA ) = '01' )
//and
// SI_MDJ_PGES_L.CODJEN2 = '10070000' AND SI_MDJ_UNEG_L.CODJEN4 = '04010000'
// AND
// SI_MDJ_PGES_L.CODJEN3 = '30000000' AND ( ( SI_MDJ_CRIT.CODJEN3 ) = '30010' )"

I tried the following, but not able to satify the criteria....

//This expression is not fully developed....

SUM

({<ACUMTEMP={'MTH'},IDESCENA= {'01'},SI_MDJ_PGES_L.CODJEN2 = {'10070000'},SI_MDJ_UNEG_L.CODJEN4={'04010000'},SI_MDJ_PGES_L.CODJEN3 = {'30000000'},SI_MDJ_CRIT.CODJEN3={'30010'}>} NUMCTCCM)

You help is greatly appreciated.... Thanks in advance for all your help.

Regards

Siva

Re: Oralce Decode function in Qlikview chart expression???

yura_ratu — Tue, 21 Jul 2015 16:51:59 GMT

Hi Siva,

Could you explain what result what do you want to get. I guess it would be faster. Not everybody here is Oracle guru

Re: Oralce Decode function in Qlikview chart expression???

maxgro — Tue, 21 Jul 2015 19:26:47 GMT

add the bold

SUM( {<ACUMTEMP={'MTH'}, IDESCENA= {'01'}, SI_MDJ_PGES_L.CODJEN2 = {'10070000'}, SI_MDJ_UNEG_L.CODJEN4={'04010000'}, SI_MDJ_PGES_L.CODJEN3 = {'30000000'}, SI_MDJ_CRIT.CODJEN3={'30010'},

INDTRANS-={T}>} NUMCTCCM)

Re: Oralce Decode function in Qlikview chart expression???

Tue, 21 Jul 2015 20:49:30 GMT

To make it simple to understand.... please check the following

SUM(DECODE(INDTRANS,'T',0, NUMCTNCM)) means

sum ( if(INDTRANS='T', 0, NUMCTNCM))

Re: Oralce Decode function in Qlikview chart expression???

Wed, 22 Jul 2015 13:52:42 GMT

Hi Massimo,

Thanks a lot for your response.

It seems your expression is correct... You really saved my day...i will get back to you after results getting verified.....

Regards

Siva

Re: Oralce Decode function in Qlikview chart expression???

sgrice — Wed, 22 Jul 2015 14:52:32 GMT

Closest match to decode is

pick() and match() used together

pick(match(myFIELD,'john','bob','fred'),'Yes yes John','No No bob','ok fred')

Re: Oralce Decode function in Qlikview chart expression???

Sun, 26 Jul 2015 12:50:19 GMT

Massimo,

Excellent....Its working correctly....Thanks for all your help. I have marked as Helpful answer, as i dont see any option to select as the correct answer.....Its strange... but Very sorry about that...

Regards

Siva