topic Re: X and Y bar in QlikView

X and Y bar

suvechha_b — Wed, 09 Sep 2015 10:03:31 GMT

Chart : X-Y Bar

My Chart look like this :

How can I get the below Chart format.

Output:

Re: X and Y bar

sunny_talwar — Wed, 09 Sep 2015 10:07:13 GMT

I think you need 2 things here:

1) Sort the bar chart in ascending order based on x axis MonthYear field. Question is, are these dates in dual format? or are they string? I would suggest creating the MonthYear using MonthName() function which will be dual in nature and can be sorted numerically.

2) You need 0 for monthyear where data doesn't exist. For that you will need to uncheck 'Suppress Zero-Values' on the presentation tab of the chart properties.

HTH

Best,

Sunny

Re: X and Y bar

suvechha_b — Wed, 09 Sep 2015 10:51:14 GMT

Sorry I was not clear in my first question.

How to get the lines ?

Re: X and Y bar

arulsettu — Wed, 09 Sep 2015 10:54:17 GMT

in axes tab increase width to 1 both

Re: X and Y bar

Wed, 09 Sep 2015 10:55:46 GMT

Go to chart properties -> Axes Tab -> in Expression Axes and dimension Axis, increase the width of the axis line.