Solved: Re: Conditional Sum - Qlik Community

Report Inappropriate Content · ‎2014-03-20

Hi,

Can somebody assist me with the correct syntax for the following expression, I have an error in the expression:

If(Sum(([Bales Loaded])-Sum([Bales Delivered]))<=0,0,Sum([Bales Loaded])-Sum([Bales Delivered]))

Thank you

PrashantSangle · ‎2014-03-20

Hi,

Use this,

If((Sum([Bales Loaded])-Sum([Bales Delivered]))<=0,0,(Sum([Bales Loaded])-Sum([Bales Delivered])))

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2014-03-20

Hi,

Use this,

If((Sum([Bales Loaded])-Sum([Bales Delivered]))<=0,0,(Sum([Bales Loaded])-Sum([Bales Delivered])))

regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-03-20

Thank you, works perfectly