Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

Stack chart unable Stack up in one bar ?

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

1 Reply
paulyeo11
Valued Contributor II

Re: Stack chart unable Stack up in one bar ?

enclosed my QVF file