Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
alexberg
Contributor II
Contributor II

Negative Werte in Tabellensummen rot darstellen

Wie kann ich in Qliksense in der Summenzeile einen Wert rot anzeigen, wenn der Wert <0 ist. Habe bereits die Hilfe durchforstet

bin aber nicht fündig geworden.

alexberg_0-1754543531616.png

Qlik Sense November 2024 Patch 2

 

Labels (1)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this 

If(Sum(YourMeasureField) < 0, Red(), Black())

Or

If(Dimensionality() = 0 and Sum(YourMeasureField) < 0, Red(), Black())

 

View solution in original post

2 Replies
Chanty4u
MVP
MVP

Try this 

If(Sum(YourMeasureField) < 0, Red(), Black())

Or

If(Dimensionality() = 0 and Sum(YourMeasureField) < 0, Red(), Black())

 

alexberg
Contributor II
Contributor II
Author

Hi

It works perfectly in a pivot table but not in a table chart. Does it work for you?