Create bar chart with 3 dimensions and one measure

[vkal12]

Hello Community,

I have a specific use case that I want to transfer from Excel to Qlik Sense. In Excel I have the following table: 

Datum	Category	Status	Value
01.01.2023	A	10	158
01.01.2023	A	20	135
01.01.2023	B	10	157
01.01.2023	C	30	786
02.01.2023	A	10	499
02.01.2023	D	20	52

From that table I create a pivot chart with the following setup: 

From that pivot table I create a pivot chart that shows the date and the category on the x-axis and creates a stacked bar chart from the status and the value. My output looks like this: 

Is there an option to create something  like this in Qlik Sense? At the moment I use a stacked bar chart where I create a concatenation from Date and Category to show them both on the x-axis. 

I would be really grateful for support. Thank you very much in advance!

[aguirre]

If you use a pivot table like in the picture attached (rows, columns and enable totals on Status).

 you can get in QLik Sense pretty much result similar to Excel.

[Or]

As far as I know, Qlik's native bar chart does not support more than two dimensions. Your concatenation solution is probably as good as it'll get.

[Renatusfreitas]

Olá @vkal12 , fiz um modelo, espero que ajude.

Aqui tenho uma amostra dos seus dados, onde irá retornar a sua tabela.

Tab:
Load * Inline [
Data, Categoria, Status, Valor
01.01.2023, A, 10, 158
01.01.2023, A, 20, 135
01.01.2023, B, 10, 157
01.01.2023, C, 30, 786
02.01.2023, A, 10, 499
02.01.2023, D, 20, 52
]

Com esses dados carregados peguei o "Gráfico de Barra" e segui com as seguintes informações:

Dimensão = Categoria&' - '&Data

Barras = Status

Medidas = Sum(Valor) (recomendo incluir nas itens mestres)

Classificar por expressão - Crescente / Data

Terá o seguinte resultado

Se essa solução lhe ajudou, marque como concluído para nos ajudar, um forte abraço!

[vinieme12]

Create a Stack bar chart then Embed that in a Trellis Container

BarChart 

Trellis Dimension

Add Bar Chart Master Visualization to Trellis Container

Tab:
Load * Inline [
Data, Categoria, Status, Valor
01.01.2023, A, 10, 158
01.01.2023, A, 20, 135
01.01.2023, B, 10, 157
01.01.2023, C, 30, 786
02.01.2023, A, 10, 499
02.01.2023, D, 20, 52
];

exit Script;