Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
LouisJ
Contributor II
Contributor II

Plot 2 measures with analog dimensions on same graph

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.

LouisJ_0-1658132548264.png

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,

LJ

Labels (2)
1 Reply
ramasaisaksoft

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