YTD With Conditional Coluring

[#1]

Hi,

i am struckid in creating ytd with conditional coluring .Kindly help me

[jagan · Accepted solution]

Hi,

Use this expression in

Text Object Properties -> Font -> Color -> Calculated and give expression below

=If(Sum({$<Year={$(=Max(Year)-1)}>} Sale) < Sum(Sale), Red(), Green())

Note: In qlikview Dimension names are case sensitive, sales and Sales both are different, in YTD expression you have given sales but it should be Sales.

Regards,

Jagan.

[#3]

Thanks  u  Bro.