topic Re: ayuda in QlikView https://community.qlik.com/t5/QlikView/ayuda/m-p/1255346#M848967 <HTML><HEAD></HEAD><BODY><P>gracias.</P><P></P><P>jose luis</P></BODY></HTML> Wed, 22 Mar 2017 12:19:31 GMT jose123456 2017-03-22T12:19:31Z ayuda https://community.qlik.com/t5/QlikView/ayuda/m-p/1255343#M848964 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">estimados&nbsp; como puedo crear esto en qlikview </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">=Sum(If([Denomination]&lt;1; [Coin In Amount]/1000; [Coin In Amount]))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/ayuda/m-p/1255343#M848964 jose123456 2020-11-25T16:16:04Z Re: ayuda https://community.qlik.com/t5/QlikView/ayuda/m-p/1255344#M848965 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>=If(Denomination&lt;1, (Sum([Coin In Amount])/1000), Sum([Coin In Amount]))</STRONG></P></BODY></HTML> Wed, 22 Mar 2017 01:56:14 GMT https://community.qlik.com/t5/QlikView/ayuda/m-p/1255344#M848965 Anil_Babu_Samineni 2017-03-22T01:56:14Z Re: ayuda https://community.qlik.com/t5/QlikView/ayuda/m-p/1255345#M848966 <HTML><HEAD></HEAD><BODY><P>Hi Jose,</P><P>Replace ';' by ',' inside If() function: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Sum(If([Denomination]&lt;1, [Coin In Amount]/1000, [Coin In Amount]))</SPAN></P><P>Regards,</P><P>H</P></BODY></HTML> Wed, 22 Mar 2017 02:49:34 GMT https://community.qlik.com/t5/QlikView/ayuda/m-p/1255345#M848966 hector_munoz 2017-03-22T02:49:34Z Re: ayuda https://community.qlik.com/t5/QlikView/ayuda/m-p/1255346#M848967 <HTML><HEAD></HEAD><BODY><P>gracias.</P><P></P><P>jose luis</P></BODY></HTML> Wed, 22 Mar 2017 12:19:31 GMT https://community.qlik.com/t5/QlikView/ayuda/m-p/1255346#M848967 jose123456 2017-03-22T12:19:31Z