Plot 2 measures with analog dimensions on same graph

LouisJ — Mon, 18 Jul 2022 08:24:08 GMT

Hello, a quick bullet chart question :

I have 2 fields : [Scheduled Month] and [Actual Month], defining the time where certain events were planned and executed.

Every row has a [Scheduled Month], but only completed events have an [Actual Month]. I would like to show on a bullet chart the monthly evolution of scheduled reports during that month compared to executed events during that month.

I can easily enough define [Scheduled Month] as the dimension, and count([Scheduled Month]) as the target. For the executed ones I have a problem, I do not know how to make the graph understand that both fields are the 'same'. I can put something like Count(If([Actual Month]=[Scheduled Month],[Actual Month])), but this is an approximation, as certain events were processed in a different month then the scheduled one, and they are simply lost.

So I guess my question is, is there a way to plot count([Actual Month]) on the same dimension as count([Scheduled Month]) ? Or any common workarounds, I'm sure this is a common use-case.

Thanks in advance,

Re: Plot 2 measures with analog dimensions on same graph

ramasaisaksoft — Mon, 18 Jul 2022 11:58:33 GMT

i think you can use stacked bar chart it will solve your issue.

topic Plot 2 measures with analog dimensions on same graph in QlikView

Plot 2 measures with analog dimensions on same graph

Re: Plot 2 measures with analog dimensions on same graph