Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating a Combo Bar-Line Chart (Dual-Axis)

Hello,

Thanks in advance. I am trying to create a combo bar-line chart, more specifically:

X Axis with Period (i.e. each month from 2012-2013)

The bar chart being represented with the number of transactions (each transaction has multiple line items, which are denoted by a transaction ID. I believe I have to sum these and then use the count function to get the Number of transactions? Please confirm).

The line chart being represented by the transaction amount.

Can someone please provide guidance on this? Currently I have:

Qlikv1.PNG.png

qlikv2.PNG.png

Where _Period = Period
_DR_Amt = Transaction Amount

_Journal_ID = Transaction ID

Below is a picture of what I want the graph to look like. This is taken from Tableau:

qlik3.PNG.png

This is what I currently have appearing in Qlikview:

qlikv4.PNG.png

I am having trouble figuring out how to get the "dual axis" on my Qlikview. I believe that is hindering my line graph from appearing. I would appreciate if someone could let me know how to do this as well.

Thanks so much!

Ryan

1 Reply
Anonymous
Not applicable
Author

On the Axes tab of your Chart's properties:

  • Highlight the Expression whose axis you wish on the right
  • For Position choose Right (Top)