topic Re: Color by expression with year(date) doesn't work in pie chart in QlikView

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

bekahbeets — Wed, 21 Jun 2017 20:54:03 GMT

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

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

devarasu07 — Thu, 22 Jun 2017 02:08:58 GMT

Hi,

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

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

Anil_Babu_Samineni — Thu, 22 Jun 2017 02:31:23 GMT

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.

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

bekahbeets — Thu, 22 Jun 2017 13:59:36 GMT

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