Stack chart unable Stack up in one bar ?

paulyeo11 — Sat, 02 Apr 2016 00:38:07 GMT

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

Re: Stack chart unable Stack up in one bar ?

paulyeo11 — Sat, 02 Apr 2016 00:39:10 GMT

enclosed my QVF file