topic Re: Stacked Bar Chart using multiple dimensions and multiple expression in QlikView

Stacked Bar Chart using multiple dimensions and multiple expression

PY — Sat, 16 Nov 2024 03:24:06 GMT

I am trying to create the chart above using the sample data above.

The expressions are

* Sum({<NT/OT={'NT'}>}Hours)

* Sum({<NT/OT={'OT'}>}Hours)

The dimensions are

* Name,

* Category -> Activity (Drill Down)

But I am unable to get them to stacked on top of each other like the chart I drew above.

Anyone has any clue?

Re: Stacked Bar Chart using multiple dimensions and multiple expression

jonathandienst — Tue, 04 Jun 2019 09:59:50 GMT

I don't think that chart is possible. You can have 2 dimensions with a single expression, or 1 dimension and 1 or more expressions, but you cannot do 2 dimensions with 2 expressions.

Re: Stacked Bar Chart using multiple dimensions and multiple expression

Brett_Bleess — Mon, 08 Jul 2019 20:48:08 GMT

See the following Help link and scroll down to the Chart Properties: Style section, that should be the details for which you are looking:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Bar_Chart.htm

Regards,
Brett

Re: Stacked Bar Chart using multiple dimensions and multiple expression

joboro — Wed, 07 Dec 2022 13:00:41 GMT

Is this still not possible? I am trying to achieve the same with Nov 2022 Version of Qlik Sense to create a simple Gantt Chart (without the need for extensions).

I would like to colour code the bar charts based on the "Code" Value but unfortunally only one dimension is valid, if two measures are used...