Re: ayuda - Qlik Community

jose123456 · ‎2017-03-21

estimados como puedo crear esto en qlikview

=Sum(If([Denomination]<1; [Coin In Amount]/1000; [Coin In Amount]))

Anil_Babu_Samineni · ‎2017-03-21

May be this?

=If(Denomination<1, (Sum([Coin In Amount])/1000), Sum([Coin In Amount]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

hector_munoz · ‎2017-03-21

Hi Jose,

Replace ';' by ',' inside If() function: Sum(If([Denomination]<1, [Coin In Amount]/1000, [Coin In Amount]))

Regards,

H

jose123456 · ‎2017-03-22

gracias.

jose luis