Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. 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 🙂