text Color of a calculated Dimension

[Frédéricdh]

Hello,

in QlikView I have this Dimension:

= If (YEAR(JWX) *100 + Week(JWX) < (Year(AddMonths(Today(1),-1)) *100 + Week(AddMonths(Today(1),-1)) +1 ) , '<= ' & (Year(AddMonths(Today(1),-1)) *100 + Week(AddMonths(Today(1),-1))), YEAR(JWX) *100 + Week(JWX))

I want to color the current Week.

How do I do this?

Best Regards

[anat]

if you expand the dimension(click on + symbol)  you can see text color or background color

 there you can write expression something like if(weekfield=week(today()),red(),while())

[Frédéricdh]

@anat 

I write this = PIck(Match( YEAR(today(1))*100 + Week(today(1))), green()) but it doesn't work

[anat]

Match function require 2 arguments

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...

=PIck(Match(YEAR(JWX)*100 + Week(JWX), YEAR(today(1))*100 + Week(today(1))), green())

example:=PIck(Match(202402, YEAR(today(1))*100 + Week(today(1))), green())