topic Re: Conditional Color Coding of LINE graph in COMBO chart in QlikView

Conditional Color Coding of LINE graph in COMBO chart

gizzel123 — Sun, 09 Aug 2015 09:40:16 GMT

Hi Guys,

I have created a CHART A, further the requirement is to conditional color code the ACTUAL/ETC and CUM ACTUAL/ETC Bar and Line graph.

If the datatype is "ETC" the part of line/bar must be yellow , if "ACTUAL " then BLUE.

here is the attached QVW.

But the issue I am facing is :

The color coding is not working if other expressions are enabled.

it we select the CATEGORY ='ACTUAL' (which has the datatype ACTUAL and ETC), then the chart color coding is displaying fine.

Please help.

lironbaram — Sun, 09 Aug 2015 10:42:11 GMT

have a look at the attach example

gizzel123 — Mon, 10 Aug 2015 07:02:44 GMT

Hi Liron,

Thanks a Lot.

Could you also explain the Maxstring() function used.

I have read that it returns string's with max value. But why did it worked here.

Thanks again

lironbaram — Tue, 11 Aug 2015 05:36:59 GMT

i used maxstring only for the propose of using set analysis i assume you could also use only function also

gizzel123 — Mon, 18 Jan 2016 13:13:49 GMT

Liron and all ,

I have the same issue again , so I have created another thread. can you please help me out with it.