topic Re: Division by Zero! in QlikView

Division by Zero!

Fri, 07 Nov 2014 14:24:57 GMT

I'll give an example: sum((Kill + Asist) /( Dead )), how do I do the same expression when Dead field is 0? When Dead field is 0, just sum(Kill + Assist).

I need to do this in text object.

Thanks.

Re: Division by Zero!

datanibbler — Fri, 07 Nov 2014 14:37:30 GMT

Hi Igor,

just put it into an IF_condition to use the neutral number 1 in case Dead=0 like

>> sum((Kill + Assist) / IF(Dead<>0, Dead, 1)) <<

Re: Division by Zero!

Aurelien_Martinez — Fri, 07 Nov 2014 14:46:24 GMT

Hi,

You can use Alt() function, like

Alt(sum((Kill + Asist) /( Dead )), sum(Kill + Assist))

Aurélien

Re: Division by Zero!

Anonymous — Fri, 07 Nov 2014 14:52:26 GMT

Hi,

You can try

if(Dead=0,sum(Kill + Assist),sum((Kill + Asist) /( Dead ))))

Re: Division by Zero!

Fri, 07 Nov 2014 15:03:43 GMT

Thanks guys!

but Jannet's response worked best!

Re: Division by Zero!

MK_QSL — Fri, 07 Nov 2014 15:46:10 GMT

Alt((Sum(Kill)+Sum(Asist))/Dead,0)

Re: Division by Zero!

MarcoWedel — Fri, 07 Nov 2014 16:01:38 GMT

Sum((Kill+Asist)*Alt(1/Dead,1))

Re: Division by Zero!

Thu, 30 Apr 2015 09:53:26 GMT

Thanks, very useful post and great answers,

If your query is resolved, mark it with correct answer!

Regards,

Kuldeep