Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

Conditional Color Coding of LINE graph in COMBO chart

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Conditional Color Coding of LINE graph in COMBO chart

hi

have a look at the attach example

View solution in original post

4 Replies
Partner
Partner

Re: Conditional Color Coding of LINE graph in COMBO chart

hi

have a look at the attach example

View solution in original post

Highlighted
Contributor

Re: Conditional Color Coding of LINE graph in COMBO chart

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

Highlighted
Partner
Partner

Re: Conditional Color Coding of LINE graph in COMBO chart

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

Highlighted
Contributor

Re: Conditional Color Coding of LINE graph in COMBO chart

Liron and all ,

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

https://community.qlik.com/message/953313#953313