topic Re: Space between chart Bars in QlikView

Space between chart Bars

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

Dear All,

I am facing problem when try to format the bar charts. The issue is when my dataset crosses over to next year the distance between December 2016 and January 2017 chart bars increases. I just want the same distance between all months chart bars.

I have also tried the options Bar distance and cluster distance but no luck. Please review the attached screenshot.

Kind Regards

Waqas Shah

Re: Space between chart Bars

swuehl — Mon, 23 Oct 2017 10:13:30 GMT

What are the dimensions / expressions you are using?

Maybe two expressions, one for each year?

Re: Space between chart Bars

satheshreddy — Mon, 23 Oct 2017 10:18:36 GMT

Hi Shah,

Better to share example file we will find the way easily.

Regards

Sathesh

Re: Space between chart Bars

waqasshah — Mon, 23 Oct 2017 10:20:35 GMT

I am using following two dimensions

Dimensions

=Left(CompleteMonthNamesRcvd,3) &'/'& RIGHT(CompleteYearNamesRcvd,2)

=CompleteYearNamesRcvd

Expressions

=NUM(SUM(IF( REF_RCVD_DT >= date(floor(monthstart(addmonths(Today(),-12))), 'YYYY-MM-DD') AND PRD_Rcvd <= date(floor(monthend(addmonths(Today(),-1))), 'YYYY-MM-DD') AND Product=ProductName AND ProductSite='Frankfurt' , TotalProducts)), '#,###.','.',',')

Re: Space between chart Bars

waqasshah — Mon, 23 Oct 2017 10:26:02 GMT

Dear Satesh,

Thanks for your repy but issue how you will extract data ? or you just want to see the formulas in chart properties?

Re: Space between chart Bars

swuehl — Mon, 23 Oct 2017 10:28:52 GMT

Maybe just remove the second dimension, I don't think it's needed.

Re: Space between chart Bars

satheshreddy — Mon, 23 Oct 2017 10:32:10 GMT

Hi Shah,

here you can use

=Left(CompleteMonthNamesRcvd,3) &'/'& RIGHT(CompleteYearNamesRcvd,2)

and exp you will get data there you have mentioned second dimension I think you are not showing anything based on second dimension.

Regards

Sathish

Re: Space between chart Bars

waqasshah — Mon, 23 Oct 2017 10:45:46 GMT

Hi Satesh,

So what you are suggesting I should not use the second dimension in my chart ?

Re: Space between chart Bars

swuehl — Mon, 23 Oct 2017 10:48:29 GMT

Right, the second dimension will create a grouped bar chart, that's why you are seeing two spaces for your expression, one is used the previous year, one is used the following year --> space between bars on year change

Re: Space between chart Bars

waqasshah — Mon, 23 Oct 2017 10:51:12 GMT

Thank You

Re: Space between chart Bars

waqasshah — Mon, 23 Oct 2017 10:51:26 GMT

Thank You