topic Re: 0 divide by 0 in QlikView

0 divide by 0

Tue, 28 Jul 2015 09:24:01 GMT

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,

arulsettu — Tue, 28 Jul 2015 09:26:38 GMT

use expression lable name instead of column

Anonymous — Tue, 28 Jul 2015 09:28:36 GMT

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 — Tue, 28 Jul 2015 09:28:44 GMT

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

Vikas

tresB — Tue, 28 Jul 2015 09:29:51 GMT

Try like:

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

antoniotiman — Tue, 28 Jul 2015 09:30:31 GMT

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

jagan — Tue, 28 Jul 2015 09:31:02 GMT

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')

=Alt(1/0, '0')

=Alt(Expression, '0')

Tue, 28 Jul 2015 09:40:24 GMT

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

Regards,