1 Reply Latest reply: Apr 1, 2016 8:39 PM by PAUL YEO RSS

    Stack chart unable Stack up in one bar ?

    PAUL YEO

      Hi All

       

      I have a stack chart work fine in QV :-

       

      it have 2 Dimension :-

       

      year

       

      =if(aggr(sum(sales),SOURCE) / aggr(sum(total <year> sales), SOURCE) > 0.001, SOURCE, 'OTHERS')

       

       

      and only 1 Expression :-

       

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      sales)

      /

      sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}

      TOTAL <year

      > sales)

       

      Mu issue is when i plot in QS use bar chart , i am not able make the bar stack up in one bar , i can only achieve individual bar stack on X axis.

       

      Enclosed my QVF sample in my next post.

       

      Paul