topic Re: Drill Down with one parent column and three columns on the same next level in App Development

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

ELozanoN — Sat, 16 Nov 2024 20:32:36 GMT

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.

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

fkeuroglian — Tue, 09 Jul 2019 17:33:49 GMT

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.htm

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