Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Zaga_69
Creator
Creator

Set analysis

Hi guys,

 

Just a simple question. I am trying to set the text color expression in a pivot table by doing:

IF(NPM_TOTAL_SALES<= 0,'red','green')

 

However, it does not work. The negative number are still in green.

 

Any idea?

 

Many Thanks,

 

Edi

Labels (1)
1 Solution

Accepted Solutions
julien_saintmaxent
Luminary Alumni
Luminary Alumni

hi,

try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')

Bye

View solution in original post

7 Replies
anushree1
Specialist II
Specialist II

Use it like : IF(NPM_TOTAL_SALES<= 0,red(),green()) or IF(NPM_TOTAL_SALES<= 0,rgb(255,0,0),rgb(0,255,0))

MindaugasBacius
Partner
Partner

IF(NPM_TOTAL_SALES<= 0,red(),green())

Use the above.

Besides why not trying.

Keep in mind the below option works only with expressions:

Screenshot_1.jpg

julien_saintmaxent
Luminary Alumni
Luminary Alumni

hi,

try with aggregation, if(sum(NPM_TOTAL_SALES)<= 0,'red','green')

Bye

View solution in original post

Zaga_69
Creator
Creator
Author

Hi

Thanks. However it does not work. 

 

julien_saintmaxent
Luminary Alumni
Luminary Alumni

can you send us screenshot of your graphice and expression please?

julien_saintmaxent
Luminary Alumni
Luminary Alumni

try to add expression with if(NPM_TOTAL_SALES<= 0,'KO','OK') in the graphic and look if it works fine.

Zaga_69
Creator
Creator
Author

Thanks!

Now it works 🙂