topic Background Colors in QlikView

Background Colors

Thu, 29 Oct 2009 15:53:27 GMT

Hi,

I need to compare 2 measures which i am plotting in a pivot chart ,

if measure1 is less than measure2 then i have show measure1 in red.

But if i give in visual clues for less tha condition as sum(measure2) and set a background color all values of measure1 are comming in that color only whether its lesser or greater.

if i try writing the expressions in the background option under measures the measure1 name is taking the color of the 1st column value.

How do i solve this issue.

Please help.

Its urgent.

Background Colors

Thu, 29 Oct 2009 16:18:23 GMT

Please see the attached file.

Thanks

Saran.

Background Colors

Thu, 29 Oct 2009 16:32:17 GMT

Thank you.

But i have my meaures in the rows .

If i shift the measures from column to rows in the ex sent by you again i am facing the same problem.

the measure name is taking the color of the first value.

Can you please help me to resolve this issue.

Background Colors

Thu, 29 Oct 2009 16:36:38 GMT

Hi,

Can you upload your sample report file. So that it will be easy for me to fix your problem.

Thanks

Saran.

Background Colors

Thu, 29 Oct 2009 16:54:56 GMT

Hi,

Please check this.

As u can see the measure name is also taking the color.I dont want it to happen.

Sorry due to some security policies cant send the exact desired report.

Background Colors

Thu, 29 Oct 2009 17:03:54 GMT

Hi,

Please check the attached file.

As you can observe the measure name is also taking the color of the 1st value.This should not happen.

Due to some security issues it is not possible for me to share the exact QVW.Sorry for that.

Please help.