topic Re: Create a dual bar chart with line in Qlikview in Reporting Service & Alerting

Create a dual bar chart with line in Qlikview

Sandy10 — Fri, 15 Nov 2024 21:56:44 GMT

I am trying to create a dual bar chart with line as sec axis. Attached the image i want to create. Yellow and Grey bars are # of customers (Total, Enrolled and Active customers)

Line is % of the customer on total customer (ex: 25000/30000=83%)

Re: Create a dual bar chart with line in Qlikview

rubenmarin — Wed, 09 Nov 2022 08:40:57 GMT

Hello, the default combo chart doesn't allows for more than one dimension, you may use some tricks to have all in one dimension but still I don't know how to draw a line that dissappears between each pair of bars and that also separates each pair of bars.

Maybe there is an extension that allows that kind of customization.

Re: Create a dual bar chart with line in Qlikview

Sandy10 — Wed, 09 Nov 2022 09:17:34 GMT

Hi Ruben. Thanks fpr your reply. My excel is like attached. Basically i want 2 datapoints on the bar (# of customer and also its relevant %) Instead of line, i can display 2 points also. Any way its possible? I cerated Type, Period as 2 dimensions.

Re: Create a dual bar chart with line in Qlikview

Sandy10 — Wed, 09 Nov 2022 09:21:31 GMT

SOmeting chart like attached. Till 2 bars is fine, % is where i am struggling. Either can be on top of bar or in bracket also.

Currently 1 exprssion is used which is # of customers

Re: Create a dual bar chart with line in Qlikview

rubenmarin — Wed, 09 Nov 2022 09:53:34 GMT

as said before, only one dimension is allowed on combo charts, so I merged both in one, the bars can't be separated in pairs, and the arkers doesn't allow to show values on chart, so I can get to this:

Or with a bar chart: (not combo)

This is using an expression with value: Dual(Num(Sum([# of Customers]),'0') &' ('&Num(Sum([% of Total customers]),'0%')&')', Sum([# of Customers]))

Re: Create a dual bar chart with line in Qlikview

Sandy10 — Wed, 09 Nov 2022 12:24:00 GMT

Hi Ruben. The 2nd one using dual the % shld be calculated or is it a manual text value? How was the 1st one created ? Thanks

Re: Create a dual bar chart with line in Qlikview

rubenmarin — Wed, 09 Nov 2022 12:48:30 GMT

Hi, it's calculated, in this case it's the value from excel EN.xls but you can change it to use the needed expression to calculate the %.

Re: Create a dual bar chart with line in Qlikview

Sandy10 — Wed, 09 Nov 2022 13:13:34 GMT

Hi Ruben/ Thank you. One alst doubt on ths, hwo to display the number in Mns and then %, basically the 1100000 as 1.1 Mn (100%) Something liek this.

Re: Create a dual bar chart with line in Qlikview

Sandy10 — Wed, 09 Nov 2022 13:15:33 GMT

Something like this in the expression. If(Sum(FieldValue)>=1000000,Num(Sum(FieldValue)/1000000,'#,##0 M'),Num(Sum(FieldValue)/1000,'#,##0 K'))

Re: Create a dual bar chart with line in Qlikview

rubenmarin — Wed, 09 Nov 2022 14:14:43 GMT

Hi, yes, you'll need something like that in the expression.