Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-07-03 10:57 AM

logarithm of Zero

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.

1,137 Views
0 Likes
10 Replies
Not applicable
‎2013-07-08 02:57 AM
Author

In response to

The was the strange situation, it worked on one computer, but didn't work on another. I used

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

106 Views
0 Likes