logarithm of Zero

[#1]

Hi guys,

Can you please help me. I don't understand why qlikview returns 1 instead of 0, if I write experssion =if(isnull(log(0)),0,1)?

Thank you.

[#2]

i think that it is because log(0) returns -1,#INF, so that's not null, try with '-1,#INF' instead of isnull()

if(log(0)='-1,#INF',0,1)

Reggards,

Santiago

[#3]

Thanks for response, but it doen't work in my app. Maybe I should mark some option somewhere?

[Sokkorn]

Hi,

Log(0) return -1,#INF mean that it have value. It not null. So the expression you used return 1 is correct. If you wish to return 0 then you can try =If(Not IsNull(Log(0)),0,1)

Regards,

Sokkorn

[#5]

It's =if(log(0)='-1,#INF',0,1) exp. looks good but doesn't work. In my task i have to check one big expression in log which sounds like as if Log (value) returns existing value than 1, otherwise 0.

=Log(0) has value '-1,#INF', but expression returns '-' not 0.

[#6]

Most probably is that your expression don´t given back 0 to be evaluated at log(), So please add yor expression on qvw or here, then we can check if there´s anything wrong.

Regards,

Santiago.

[#7]

You can see .qvw in attachment before. I used your 'IF' statement

[#8 · Accepted solution]

try the below

=replace(text(num(log(0))),'-1.#INF',0)

[#9]

Hi , look if this work for you, be care that 'Supress zero values' wasn't clicked on presentation tab.

Regards.

Santiago

[Sokkorn]

Hi,

Use this in your text object =If(WildMatch(Log(0),'*#INF*'),0,1)

Regards,

Sokkorn