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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Adrian1979
Contributor
Contributor

Straight table visual clues

I have a straight table which shows the sum of a field by date, and sorted by date.

I want to show if the current value is higher or lower than the proceeding date value using the visual clues - is this possible?  I want it to go green if it higher or red if it is lower.

Labels (1)
1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

Maybe use something like this in Background color box;

=if(RowNo()=1,null(),
if(above(sum(mea))>sum(mea),
Red(),Green())
)

20220314_1.png

Cheers,

Chris.