topic Re: custom axes on a bar chart in QlikView

custom axes on a bar chart

ali_hijazi — Mon, 30 Jun 2014 13:21:03 GMT

hello

working on a bar chart with stacked as style

the expression is showing by month the percentage of closed and open tickets

so far so good

but the Y-axis is showing the %

what I want to show on the Y-axis is the total number of tickets

my dimensions is Month

I have 2 expressions

count({<condition of closed>} ticketId )/count(ticketID)

count({<condition of opened>} ticketID)/count(ticketID)

please advise

Re: custom axes on a bar chart

Anonymous — Mon, 30 Jun 2014 13:25:07 GMT

try adding another expression cound(ticketID) to the list of expressions and promote it to the top. in axes tab, you may want to set count(ticketID) as axis Position to Left (Bottom) and the other two expressions with axis Position to Right (Top) and you could decide if you want to hide the axis on right.

Re: custom axes on a bar chart

ali_hijazi — Mon, 30 Jun 2014 13:27:44 GMT

but I don't want to show the bar of the total per month

Re: custom axes on a bar chart

Anonymous — Mon, 30 Jun 2014 13:33:08 GMT

turn that to invisible. there is a check mark below the Comment field.

Re: custom axes on a bar chart

SunilChauhan — Mon, 30 Jun 2014 13:36:28 GMT

go to chart properties--->number ----> select express one by one and untick show in % at the bottom

hope this helps

Re: custom axes on a bar chart

ChiragPradhan — Mon, 30 Jun 2014 16:32:30 GMT

Hi Ali

I have attached a sample I created. The other option is to use a combo chart and display the percentages on a line chart, make the line invisible and display the totals on the Bar chart.

Hope it helps !

Regards

Re: custom axes on a bar chart

ali_hijazi — Tue, 01 Jul 2014 06:51:02 GMT

this is very helpful

but can we simply plot the percentages inside the other bars?

Re: Re: custom axes on a bar chart

kji — Tue, 01 Jul 2014 12:33:04 GMT

like this?

Re: custom axes on a bar chart

ChiragPradhan — Tue, 01 Jul 2014 12:40:02 GMT

Dual is the answer !