Color by expression with year(date) doesn't work in pie chart

[bekahbeets]

So i have the following expression in the color by expression editor:

if (year([Date of Service])= 2015, blue(),

if (year([Date of Service])= 2016, yellow(), 

if (year([Date of Service])= 2017, red(), green())))

It works in the bar chart, but not in the pie chart? I am a bit confused

[devarasu07]

Hi,

expression seems no issue and its working. can you brief more. tks

[Anil_Babu_Samineni · Accepted solution]

I suggest you to create the Year field in Script like Year([Date of Service]) as Year and then use same expression instead of calc. use Year is the straight forward.

[bekahbeets]

I am in Qlik Sense desktop. Do qvw files work there?