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: 
aaronnayan
Creator III
Creator III

In chart text colour conditioning

Hi Guys

I have an expression its not coming out right

Metrics

0-50= RED

51-70= YELLOW

70-90=GREEN

90+= BLUE


This is whats coming out currently


2017-07-06_13h46_41.png

Can anyone help with this

If you could write the correct expression it will help significantly

4 Replies
Frank_Hartmann
Master II
Master II

can you upload a small sample?

dberkesacn
Partner - Creator III
Partner - Creator III

When you making the avg you have to use agg function.

if(aggr(sum(Value),Dim)/aggr(Count(Value),Dim)<10,red(),Green())

aaronnayan
Creator III
Creator III
Author

This 51 should be yellow but it is not

Anil_Babu_Samineni

Can you try this?

If(Avg(Date) >= 0 and Avg(Date) <= 50, Red(), If(Avg(Date) >= 51 and Avg(Date) <= 70, Yellow(), If(Avg(Date) >= 71 and Avg(Date) <= 90, Green(), Blue())))


But, I doubt how Avg(Date) given the values to you?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)