Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vkal12
Creator
Creator

Create bar chart with 3 dimensions and one measure

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: 

vkal12_0-1678359353134.png

 

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: 

vkal12_1-1678359404413.png

 

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!

Labels (4)
4 Replies
aguirre
Creator
Creator

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
MVP
MVP

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
Partner - Contributor III
Partner - Contributor III

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)

Renatusfreitas_0-1678363858756.png

 

Classificar por expressão - Crescente / Data

Renatusfreitas_1-1678363939640.png

Terá o seguinte resultado

Renatusfreitas_2-1678364068543.png

 

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

 

 

 

 

 

Se está solução ajudou, aceite-a como uma solução.

https://br.linkedin.com/in/renatusfreitas

https://cubotimize.com/
vinieme12
Champion III
Champion III

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

 

 

BarChart 

vinieme12_0-1678693635933.png

 

Trellis Dimension

vinieme12_1-1678693680740.png

 

 

Add Bar Chart Master Visualization to Trellis Container

vinieme12_0-1678693543342.png

 

 

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;

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.