topic Re: Expression to QV in QlikView https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998352#M949364 <HTML><HEAD></HEAD><BODY><P>Try to break it into small ones and then try<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Dec 2015 10:43:26 GMT Anonymous 2015-12-11T10:43:26Z Expression to QV https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998351#M949363 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>what would be the expression for below one</P><P></P><P>sum(CASE WHEN A.METHOD_ORIGINAL != 'STD' AND(</P><P>(DECODE(A.METHOD_NEW,'STD','SEG',A.GUARANTEE_METHOD)='LGD' AND A.TRANCHE_GUARANTEE_TYPE='GUARANTEED') OR (A.TRANCHE_COLLATERAL_TYPE='COLLATERALIZED' AND A.COLLATERAL_BIS_PRODUCT='IMP_LGD_EFF') OR A.TRANCHE_COLATERAL_TYPE ='COLLATERALIZED' AND A.COLLATERAL_BIS_PRODUCT IN ('RRE_COL', 'LEASING_CRE_COL','CRE_COL','OTHER_PH_COL','LEASING_EQUIPMENT_COL','LEASING_RRE_COL','RECEIVABLE_COL')) THEN ROUND(A.COLLATERAL_ASSIGNED_AMMOUNT/(B.EXCH_RATE*1000),5)</P></BODY></HTML> Fri, 11 Dec 2015 09:57:05 GMT https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998351#M949363 priyarane 2015-12-11T09:57:05Z Re: Expression to QV https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998352#M949364 <HTML><HEAD></HEAD><BODY><P>Try to break it into small ones and then try<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 11 Dec 2015 10:43:26 GMT https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998352#M949364 Anonymous 2015-12-11T10:43:26Z Re: Expression to QV https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998353#M949365 <HTML><HEAD></HEAD><BODY><P>I am trying but no luch, can some one please help me here</P></BODY></HTML> Fri, 11 Dec 2015 13:36:39 GMT https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998353#M949365 priyarane 2015-12-11T13:36:39Z Re: Expression to QV https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998354#M949366 <HTML><HEAD></HEAD><BODY><P>Maybe it's me, but that DECODE statement doesn't seem to make sense.</P></BODY></HTML> Fri, 11 Dec 2015 14:32:40 GMT https://community.qlik.com/t5/QlikView/Expression-to-QV/m-p/998354#M949366 roger_stone 2015-12-11T14:32:40Z