2 dimensions, 2 expressions - line chart

reshma_km — Wed, 25 Nov 2020 16:16:04 GMT

hi,

i have a line chart with 2 dimensions - YearQuarter(like 2016-Q1), doctor(name).

it has one expression only({<doctor=>}metric1)

it also has a background expression.

so, we get a bunch of light blue lines for all the doctors with the selected doctor's line highlighted in dark blue.

it is working fine.

now, i would like to add a second expression only({<doctor=>}metric2).

i disabled first expression, and then the new expression is working fine. we get a bunch of light green lines for all the doctors with the selected doctor's line highlighted in dark green.

the requirement is to have both these expressions (2 groups of lines) in the same chart.

i tried combo chart with different values for "position" in "axes" tab. but its not working properly.

can you please help me out?

topic 2 dimensions, 2 expressions - line chart in QlikView

2 dimensions, 2 expressions - line chart