Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a table for Profit and Analysis Report with 7 levels of hierarchies which is displayed in Pivot table. In Pivot table, drill down is shown from level 1 to level 7. But the requirement is to customize the hierarchy. (ie) To show some element in Hierarchy 1, Hierarchy 2 and Hierarchy 4 at first level. Please help me to know if there are any extensions available for this. Attaching the screenshot of the existing layout,
Is it possible to have visualization that caters the need where to show EBITDA, Delivered Margin, Amortization at a single level,
Thanks a lot,
Selva
Hi Selva,
Check out the smart reporting extension in qlik branch using the link below. I think this may help for what you are looking for.
The search for the text smart.
david
Hi Selva,
Check out the smart reporting extension in qlik branch using the link below. I think this may help for what you are looking for.
The search for the text smart.
david
Thanks David.
Have gone through the extension. It would be more helpful if you could please let me know if there are any extensions where there is possibility of including Dimensions as 'Rows' rather than 'Columns'.
Thank you
Selva
Hey David,
Thank you. With some modifications in SQL, we can able to show the PNL report in the expected format. Just a small clarification. In that extension, if we use 'monthname' formula to display the months, its showing January as 'ENE', April as "Abr'. Is there a way to show English calendar the same way. Any specific formula to use to achieve the same. Kindly assist.
Also i have tried creating drill down dimension with Account Group and Account code. But it isn't working in the extension. Can you please help on this aspect as well.
Thanks,
Selva
Hi, I don't have an answer to date. I suggest you put a request on the branch project and ask the developer of the extension.
rgds
David