Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

On the Axes tab of your Chart's properties:

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