Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
khadraouihiba02
Contributor III
Contributor III

How can I color negative values and positive values in QlikView?

Hello,

How can I color negative values red and positive values green in QlikView?

 

 

1.png

2.png

  

Labels (1)
16 Replies
khadraouihiba02
Contributor III
Contributor III
Author

@anat i don't know what i create in  the function

if(sum(what i crate here?))

anat
Master
Master

if((N-(N_1)/(N_1))*100>0,green(),red())

khadraouihiba02
Contributor III
Contributor III
Author

@anat  the histogram change to green, i don't know what's the problem

10.png

11.png

  

not the value

anat
Master
Master

can you confirm which below option you have selected?

anat_0-1713546333248.png

 

khadraouihiba02
Contributor III
Contributor III
Author

@anat 

12.png

anat
Master
Master

in bar chart i can see only 1 bar measure values but in expression i can see 2?

anat_0-1713547333347.png

 

khadraouihiba02
Contributor III
Contributor III
Author

@anat yes because the first expression objectif it's for the indicators 

13.png