Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
lorenbo
Contributor
Contributor

Conditional formatting based on previous measure value

Hi all!!!

I would like to create a table which highlights the value change from one week to the previuos one (pls see the example).

I know i can set the condition in the color expression of the measure in the table, but i don't know how to write the condition.

Could you please help me?

Thanks

2 Replies
Yoshidaqlik
Creator II
Creator II

Hi

fine?

 

Will you use a table with these manual adjustments?

if you use it in color you can put an if

If(
  Sum(dim_manual)>0,Red(),Green()
)
YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng
lorenbo
Contributor
Contributor
Author

Hi

yes, it is a table.

I solved using the after() function!

Thanks all