Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
kumarreddy257
Creator
Creator

Divide by zero

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

1 Solution

Accepted Solutions
jagan
MVP
MVP

Hi,

Use Alt() like below

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

Example:

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

Hope this helps you.

Regards,

Jagan.

View solution in original post

3 Replies
qlikpahadi07
Specialist
Specialist

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

ziadm
Specialist
Specialist

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

jagan
MVP
MVP

Hi,

Use Alt() like below

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

Example:

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

Hope this helps you.

Regards,

Jagan.

View solution in original post