Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am developing the PNL in Qlik Sense. It has multiple levels and parent child relationships. For example:
Revenues
--Revenue from Stores
--Revenue from WebSales
Cost of Goods
--Cost of ...
-----Cost of .......
And in this way the level are not balanced but hierarchial.
The user needs results in levels. Let say they see the first level at first which is:
Revenues
Cost of Sales
Gross Profit
Other Income
Admin Expenses
Hr Cost
...
EBITDA
..
Net Profit or Loss
and then if they clik on Cost of Sales, its lower levels are shown.
How to do this in Qlik Sense.?
Hi Mohammad,
It would be better to see sample data. Maybe you can mock up a spreadsheet of the detail?
For revenue, could you create an attribute: Revenue Source ("Store","Web") and Revenue Source Name (e.g. store name, website address). What is the parent-child relationship with revenue? Could you give some detail for cost of goods as well?
I'm having to deal with a similar situation where I have child dimensions for measures which are at the parent level.