how to do Bar offset only for group of stack bar chart

Fri, 26 Sep 2014 04:36:24 GMT

hi all,

i want help to over come this scenario,

i have developed one chart shown below

expression used in bar chart = if(ValueList('pve','nve')='pve',if((vEBITDA_Periodic)>0,$(vEBITDA_Periodic)),if($(vEBITDA_Periodic)<0,$(vEBITDA_Periodic)))

vEBITDA_Periodic = (SUM({$<SUMACCOUNT={'5211000','5205005','5205006','5205001'}-{'5208000','5207000','5205002'},

ACT={'AC'},QuarterID={$(=max(QuarterID))}+{$(=max(QuarterID)-4)}, QuarterYear=,Quarter= >} PERIODIC))

******Requirement Question *****

1.To show +ve value stack and –ve value Stack together(Grouped) by Company name
2.–ve value shuld start from –ve stack scale and +ve value also start from –ve stack scale as shown in below chart
3.User can select year and quarter field,
4.And chart should show current year or selected year quarter and last year same quarter

output chart look like

topic how to do Bar offset only for group of stack bar chart in QlikView

how to do Bar offset only for group of stack bar chart