Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
aaronnayan
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


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
Honored Contributor II

Re: In chart text colour conditioning

can you upload a small sample?

Partner
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())

aaronnayan
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)