topic Re: How to in QlikView

How to

smilingjohn — Thu, 05 Nov 2015 10:58:46 GMT

HI i have a water fall model ,

I want to show each legend should start from the ending of the first legend (2013-2014) and so on

The concep is correct but u can see that all the basrs will at at the first bar(2013-2014) edge , but i want all the bars except the last on to be showed from the ending of first bar(2013-2014)

Please find the attahment

Re: How to

tresB — Thu, 05 Nov 2015 11:08:19 GMT

Is the issue with only the last bar? That is actually not starting from edge of first bar. It is actually starting from the base of the axis and reaching till 2075 (which appears to be what you probably interpreting as.

Re: How to

smilingjohn — Thu, 05 Nov 2015 11:12:37 GMT

Hi tresesco

No the last bar and first bar are correct, I want all the other bars to start from the veritcal ending of first bar, Becuase First bar is for 2013 to 2014 , and bar next it starts from 2014to 2015 ,

I hope I am clear .

Thanks inAdvance

Re: How to

Mark_Little — Thu, 05 Nov 2015 11:24:30 GMT

Hi John,

I am not sure exactly what you are trying to achieve?

Are you just trying to join the bars.

Properties > Presentation > Bar Distance. Set to 0?

Re: How to

tresB — Thu, 05 Nov 2015 11:25:51 GMT

Do you want the bars to go upward? If so, then for bar offset expression use just first bar expression, i.e. -sum([RFQ 2013-14])