Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Cameron94
Partner - Contributor III
Partner - Contributor III

If function with division expression

This is my current calculation:

column(7)/column(11)

Usually I would utilize an if statement like this:

If (column(7)/column(11)>0,column(7)/column(11),'') 

Which would show all available numbers over 0. However this expression doesn't work as expected.

So was wondering if it is possible to achieve something similar with a different approach. 

Thankyou 

Labels (3)
1 Reply
marcus_sommer

Instead an if-loop you may try something like:

rangemax(column(7)/column(11), 0)