Discussion board where members can get started with QlikView.
I have an expression its not coming out right
This is whats coming out currently
Can anyone help with this
If you could write the correct expression it will help significantly
can you upload a small sample?
When you making the avg you have to use agg function.
This 51 should be yellow but it is not
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?