# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
Contributor 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

Can anyone help with this

If you could write the correct expression it will help significantly

4 Replies
Honored Contributor II

## Re: In chart text colour conditioning

can you upload a small sample?

Partner

## Re: In chart text colour conditioning

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

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

Contributor III

## Re: In chart text colour conditioning

This 51 should be yellow but it is not

## Re: In chart text colour conditioning

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?

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)