Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ELozanoN
New Contributor

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

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.

Labels (4)
1 Reply
Partner
Partner

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

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