Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Color the text

Hi Everyone,

         I am new to Qlik Sense and my requirement is, I have a field called Source System and it has three values A, B and C and I used If condition to split that three values to be three different columns. for example, if(source System ='A', Source System) likewise for the other two. Now I have one more field called as net price and that field has different values for different source systems. My requirement is to color that net price if it is common between any source system. 

 For example, if  A and B source system is having the net price of 10 then I have to color that 10  or If A and C has a common net price like 2345 then I have to color that. I could not achieve that Could someone help me, please.

1 Reply
dwforest
Specialist II
Specialist II

You don't say what visualization you are using, but you would put a formula in the Background Color Expression field (if it has one),
if(test, #FF00000).
test would be maybe Net_Price_A = Net_price_B or Net_Price_B = Net_Price_C or Net_price_A=Net_Price_C