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: 
suvechha_b
Creator III
Creator III

Please kindly assist me in getting the expression correctly .

Hi All ,

Please kindly assist me in getting the expression correctly .

My requirement is if there was a increase from the previous month the ration should display in green , and if there is a decrease , it should be shown as red.

Capture.PNG

Say for eg , the Ratio for month Mar 2018 should be red as it decrease . and April should also be red.

Sample model attached.

Thanks,

1 Solution

Accepted Solutions
sunny_talwar

Try Before() instead of Above()

=if(Before([Ratio])>([Ratio]),rgb(255, 0, 0),Green())

View solution in original post

3 Replies
sunny_talwar

Try Before() instead of Above()

=if(Before([Ratio])>([Ratio]),rgb(255, 0, 0),Green())

sunny_talwar

Also read about Before() and After() functions here

Missing Manual - Before() and After()

suvechha_b
Creator III
Creator III
Author

Thank you