Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

hi all,

i want help to over come this scenario,

i have developed one chart shown below

Group of Stack bar.png

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

output chart look like

Group of Stack bar output.png

0 Replies