Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioCenteno
Creator III
Creator III

Function Column()

I'm trying to paint a kpi when it's greater than 0.95 that is green otherwise it's red, I'm using the column () function but apparently I'm doing something wrong.


Current expression:

IF (Column(4) >0.95, RGB(0, 255, 0), RGB(255,0,0))


QLIK.png


Labels (3)
1 Solution

Accepted Solutions
michaelsikora
Contributor III
Contributor III

Try Column(3) and make sure the number is an integer.

View solution in original post

6 Replies
michaelsikora
Contributor III
Contributor III

Mario,

Instead of using the column function, try going to the expression and clicking the plus arrow. Once doing that you double click "Background Color".

Then use the expression in in column 4 (instead of sum(NetSales), use your expression) like below:

If(Sum(NetSales)>.95, RGB(0,255,0), RGB(255,0,0))

MarioCenteno
Creator III
Creator III
Author

I was already doing so but my expressions are too long, so I try to reduce the code with the column () function.

michaelsikora
Contributor III
Contributor III

IF (Column(4) >0.95,RGB(0,128,0), RGB(230,0,0))

MarioCenteno
Creator III
Creator III
Author

It does not work, I have the same function and apparently there is some error.

michaelsikora
Contributor III
Contributor III

Try Column(3) and make sure the number is an integer.

MarioCenteno
Creator III
Creator III
Author

It worked in the following way

If (Column( 3 )> 0.95, RGB (0.255,0), RGB (255,0,0))