Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kumarreddy257
Contributor

Divide by zero

Hello experts,

I have expressions like this

count(DISTINCT{$<[Page2]={'www:cart:cloudSmiley Tongueroduct'},[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

1 Solution

Accepted Solutions
MVP
MVP

Re: Divide by zero

Hi,

Use Alt() like below

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

Example:

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

Hope this helps you.

Regards,

Jagan.

3 Replies
qlikpahadi07
Valued Contributor

Re: Divide by zero

you can write a expression like

if(count(DISTINCT{$<[Page2]={'www:cart:cloudSmiley Tongueroduct'},[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

ziadm
Valued Contributor

Re: Divide by zero

Try Alt function

having

Alt(count(DISTINCT{$<[Page2]={'www:cart:cloudSmiley Tongueroduct'},[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

MVP
MVP

Re: Divide by zero

Hi,

Use Alt() like below

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

Example:

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

Hope this helps you.

Regards,

Jagan.

Community Browser