Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

0 divide by 0

Hi friends,

Need a small help with the problem i am facing with when column(1) and column(2) has zero values

So when i using column(3) = column(1) / column(2) , it is showing ' - ' or blank, for which i am not able to use proper Traffic LED light.

Any suggestions to overcome with problem are most welcomed.

Regards,

KC

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try  like:

Alt( column(1) / column(2) , 0)

View solution in original post

7 Replies
arulsettu
Master III
Master III

use expression lable name instead of column

Anonymous
Not applicable
Author

Hi,

can help this?

If(Column(1)=0 and Column(2)=0, <data that you need for your Traffic LED light>, column(1) / column(2))

Regards.

vikasmahajan

copy formula for column(1) / also copy formula for colm 2    and use this expression to arrive traffic light.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
tresesco
MVP
MVP

Try  like:

Alt( column(1) / column(2) , 0)

antoniotiman
Master III
Master III

Alt(Column(1)/Column(2),0)

jagan
Luminary Alumni
Luminary Alumni

Hi,

Anything divide by zero you will get 0, if you want to give any value for null then use Alt() like below

=Alt(1/0, 'Default Value')

OR

=Alt(1/0, '0')


OR

=Alt(Expression, '0')

Not applicable
Author

Thanks all for your quick help. Really appreciate your efforts.

Regards,

KC