Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Background Colors

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.

5 Replies
Not applicable
Author

Hi

Please see the attached file.

Thanks

Saran.

Not applicable
Author

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.

Not applicable
Author

Hi,

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

Thanks

Saran.

Not applicable
Author

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.

Not applicable
Author

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.