Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jose123456
Contributor
Contributor

ayuda

estimados  como puedo crear esto en qlikview

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

3 Replies
Anil_Babu_Samineni

May be this?

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
hector_munoz
Specialist
Specialist

Hi Jose,

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

Regards,

H

jose123456
Contributor
Contributor
Author

gracias.

jose luis