Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

how to apply multiple background color in line chart


In my data file, there were three columns: Month, Value and Type. Type can be either 'A' or 'B',  and those two types of data need to be showed in one single continuous line. In this chart, I want to mark 'A' in one color and 'B' in a different color.

the expression is    =sum({1<Type={'A','B'}, Month=  >}Value)

and I put    =if(Type='A', red(), green()) in the background color

The color does not change.

Can someone please help me with that?



Tags (3)
Community Browser