Drill Down with one parent column and three columns on the same next level

[ELozanoN]

Hi, I am using Qlik Cloud. So I have a table with the P&L of a company. In this table I have columns for rents, paysheet and operation. I also have a column with the sum of those other columns which is called Fixed costs. I am asked to show on a pie chart the percentage of the total fixed costs that each concept (rent, paysheet and operation) represents. I would also like to drill-down Fixed expenses, so that I create a bar graph with Fixed and Variable, and drill down through fixed costs to show rent, etc...

I would really appreciate the experts help. Thank you so much in advance.

[fkeuroglian]

Hi how are you

In some places, you have to said qlikview what is the hierarchy that you have

for example, this can be an excel that have diferents levels, see this post example

https://help.qlik.com/es-ES/qlikview/November2017/Subsystems/Client/Content/DataSource/Hierarchies.h...

Other way (a bit difficult) could be use the function HIERARCHY in qlikview to create this levels.

In some way or another you have to said qlik what is the levels and how is the relation between the fields you want to create the drill down

Hope helps

Fernando