topic Re: Divide by zero in QlikView

Divide by zero

Anonymous — Thu, 09 Apr 2015 04:48:45 GMT

Hello experts,

I have expressions like this

count(DISTINCT{$<[Page2]={'www:cart:cloud:product'},[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

and it is calculating zero and want to use value as in denaminator (i.e a/b). If i use this value it is giving blank, but i want to display one message.

Pls help me on this.

Thanks in advance.

Regards,

kumar

Re: Divide by zero

qlikpahadi07 — Thu, 09 Apr 2015 04:52:20 GMT

you can write a expression like

if(count(DISTINCT{$<[Page2]={'www:cart:cloud:product'},[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID]) =0,'message',<expression>)

or simple

if(len(a/b>1,a/d,'Message')

you can use Null functions too instead of Len

Re: Divide by zero

ziadm — Thu, 09 Apr 2015 05:00:23 GMT

Try Alt function

having

Alt(count(DISTINCT{$<[Page2]={'www:cart:cloud:product'},[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID]),0)

This should return the count if its a valid number otherwise 0

maybe you could have different aggregation over different selection instead of returning zero

Regards

Ziad

Re: Divide by zero

jagan — Thu, 09 Apr 2015 07:14:11 GMT

Hi,

Use Alt() like below

=Alt(Expression, 'Value If expression returns null')

Example:

=Alt(100/0, 'N/A')

Hope this helps you.

Regards,

Jagan.