Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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