topic Create a multi dimensional Bar chart in App Development

Create a multi dimensional Bar chart

yousra_badra — Fri, 02 Apr 2021 08:23:30 GMT

I want to create a simple stacked bar chart like the attached. each bar in the x-axis is a separate dimension and has to be stacked. is there a way to group multiple dimensions in one dimension to create this graph?

Thank in advance 🙂

Re: Create a multi dimensional Bar chart

Gui_Approbato — Sun, 29 Mar 2020 20:26:46 GMT

Hi Yousra,

I don't know what your columns are, but try to follow this example:

First I made a stacked bar chart (just adjusted the option to make it stacked):

The dimensions were "Estado" (State name), "Cultivo" (Crop name) and the measure was Sum(Área).

Then, to divide it by the total of each State (Estado) I had to change the measure to this:

Sum(Area)/Sum(Total <Estado> Area)

With this expression the calculation is based on the total of each Estado:

I hope it helps.

Cheers

Re: Create a multi dimensional Bar chart

yousra_badra — Mon, 30 Mar 2020 06:35:24 GMT

Thank you for your reply. my problem is the dimension as each bar is a separate dimension. TD, PP, BP and so on. how can I group them all in one chart?

Thanks in advance

Re: Create a multi dimensional Bar chart

Gui_Approbato — Tue, 31 Mar 2020 12:46:36 GMT

Ah, I see..

In this case you need to use the 'Crosstable' in the script editor.

With the crosstable function you will 'unpivot' the columns and transform them in one column.

https://help.qlik.com/en-US/sense/February2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes/crosstable.htm