topic Re: Combo Chart (line/bar) in QlikView

Combo Chart (line/bar)

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

Hello Community.

I have a line chart that shows the years planned sales data. I would like to add a bar chart, but only one bar showing the total planned for the current month. So given this is July, my chart would show the 12 month line chart and one bar for July showing the total, like the attached.

Any help will be truly appreciated.

Re: Combo Chart (line/bar)

Lisa_P — Thu, 19 Jul 2018 22:55:16 GMT

Create the chart with all the measures and add in the measure for the current month by applying set analysis to limit it to only the current month

Sum({<Month={$(=Month(Today()))},Year={$(=Year(Today()))}>}GatewaysActual)

This will work out the current month and year and apply that as a filter

Re: Combo Chart (line/bar)

ZoeM — Fri, 20 Jul 2018 14:26:01 GMT

Hi Lisa,

Thanks for that suggestion. I tried adding the month portion of the set analysis you provided and the expression doe snot like it, not sure if I used variables it recognized.

Re: Combo Chart (line/bar)

Anil_Babu_Samineni — Mon, 23 Jul 2018 13:57:38 GMT

I have work around, If you can provide sample data set