topic Re: One-Bar Stacked Bar Chart in QlikView

One-Bar Stacked Bar Chart

Mon, 12 Dec 2016 15:43:39 GMT

Hi all,

as the search didnt get me a suitable answer I ask you guys to help me.

I try to make a Stacked Bar chart with only one bar divided by areas and it should display the difference to last week.

So the bar in total is the complete difference to last weeks value and that divided by areas in the stacked bar.

I tried several things and variations of expressions like restrict the dimension to the largest week and sum()-below(sum) and so on.

Nothing worked out yet.

Do you guys have an idea?

Best regards,

Seb

Clever_Anjos — Mon, 12 Dec 2016 15:51:52 GMT

Not sure I´m following you.

Maybe if you post a sample of your data and a prototype (Paint, Excel, whatever) we could figure out a way to help you

Mon, 12 Dec 2016 16:00:56 GMT

This is a super simplified mockup I try to give you a sample but this will take some minutes.

Clever_Anjos — Mon, 12 Dec 2016 16:10:24 GMT

4 expressions and 0 dimension solves your need?

Clever_Anjos — Mon, 12 Dec 2016 16:14:12 GMT

Attaching my sample

Mon, 12 Dec 2016 16:15:22 GMT

Here is a super super simplified sample. The original data is much more detailed with more subareas and so on

Tue, 13 Dec 2016 15:07:24 GMT

Unfortunately it doesnt solves my need.

If I would do it with only expressions I cant filter by Area or whatever.

It must be dynamic.