Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

varaince in color

hi all

i am trying to do mark upward arrow and downward arrow. blue color for upward and red color for downward

for this first i master measure . in segment section i did this 

capriconuser_0-1659437616156.png

 

in expression i add master measure and did this 

 

capriconuser_1-1659437931971.png

 

 

now in variance arrow is down but not in red color. arrow is in blue color. i want when arrow down then should be red and upward then shoud be blue

 

expression which i add 

[Amount Current Year] - [Amount Previous Year]

 

Labels (2)
2 Replies
Mark_Little
Master
Master

Hi @capriconuser 

to change the text colour i believe you will need to add an expression in the chart properties > Text Colour Expression 

capriconuser
Creator
Creator
Author

ok what kind of expression i should add