Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

ayuda

estimados  como puedo crear esto en qlikview

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

3 Replies
Highlighted

Re: ayuda

May be this?

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

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)
Highlighted
Specialist
Specialist

Re: ayuda

Hi Jose,

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

Regards,

H

Highlighted
Contributor
Contributor

Re: ayuda

gracias.

jose luis