Complex expression for colors is causing problems with "Show Legend"

helen_pip — Tue, 20 Mar 2018 12:10:16 GMT

Dear Qlikview user

I have a complex expression which is to calculate the colour of the line in a line chart, depending what options the end user selects

However when I add the expression, I get the following error message: "Drawing of Chart Failed internally"

I have to either untick the "Show Legend" on the presentation tab or take the expression out of the Background colour option under the Expressions tab in order to get the chart to show

I am not sure whether Qlikview can cope with the complex expression and getting the legend to show the same colors accordingly

Has anyone come across this issue before?

Background Color Expression:

Pick(Match(CWT_Analysis_Category, 'Two Week Wait','31 Day','62 Day'),

Pick(Match(_view_CWT_Analysis_2WW,'Week 1 vs Week 2','First 10 Days vs Last 4'),

Pick(Match(CWT_Analysis_Week_Group_1,'Breach','0 - 7 Days','8 - 14 Days'),$(vColour_Fail_Target),$(vColour_Dark_Grey),$(vColour_Medium_Blue)),

Pick(Match(CWT_Analysis_Week_Group_2,'Breach','0 - 10 Days','11 - 14 Days'),$(vColour_Fail_Target),$(vColour_Dark_Grey),$(vColour_Medium_Blue))),

Pick(Match(CWT_Analysis_Period,'Breach','Same Day','Last 10 Days','Within 21 Days','Within 31 Days','Within 52 Days'),

$(vColour_Fail_Target),

$(vColour_Dark_Grey),

$(vColour_Medium_Blue),

$(vColour_Med_Blue),

$(vColour_Dark_Blue),

$(vColour_Darker_Blue)),

Pick(Match(CWT_Analysis_Period,'Breach','Same Day','Last 10 Days','Within 21 Days','Within 31 Days','Within 52 Days'),

$(vColour_Fail_Target),

$(vColour_Dark_Grey),

$(vColour_Medium_Blue),

$(vColour_Med_Blue),

$(vColour_Dark_Blue),

$(vColour_Darker_Blue)))

Any help or advice would be appreciated

Kind Regards

Helen

Re: Complex expression for colors is causing problems with "Show Legend"

YoussefBelloum — Wed, 21 Mar 2018 10:27:28 GMT

Hi,

would you be able to attach some data ? or a sample QVW ?

topic Re: Complex expression for colors is causing problems with "Show Legend" in QlikView

Complex expression for colors is causing problems with "Show Legend"

Re: Complex expression for colors is causing problems with "Show Legend"