topic Re: Line Chart Color Coding Issue in QlikView

Line Chart Color Coding Issue

Anonymous — Thu, 20 Aug 2015 06:56:12 GMT

Hi Team,

I've line chart(Added Circle as Symbol) with 'Year' as Dimension and 'Sum(Sales)' as Measure . when I selected one year it displays last four years data.My requirement is selected year sales are less than previous year it has to show Red color for that year line as shown in image. Issue is the end of the line chart also display red if the line is red but it displays as green. Color code is given in Expression tab->Background color as

=if(yearend(max([Year1]),-1)=yearend(max([Year]),-2) ,

if(

$(Sales_YTD)-$(Sales_PrevYTD)>0,

RGB(0,176,80), RGB(192,0,0)),

RGB(0,176,80)

)

Please any one help me for resolving this issue.

Re: Line Chart Color Coding Issue

jonathandienst — Thu, 20 Aug 2015 07:01:56 GMT

Did you mean your expression to refer to Year1 and Year? Or is that just a typo.

I suggest that you post your application or a representative sample to get more accurate and useful help.

Re: Line Chart Color Coding Issue

Anonymous — Thu, 20 Aug 2015 07:03:58 GMT

Year1 and Year

Re: Line Chart Color Coding Issue

jonathandienst — Thu, 20 Aug 2015 07:09:20 GMT

Hmm - is that a yes or a no? There are two separate fields? Post your model or sample please.

Re: Line Chart Color Coding Issue

Anonymous — Thu, 20 Aug 2015 08:43:43 GMT

Yes I've year1 and year fields.

Thank you Jonathan Dienst for your quick response .I got the solution for this.