Qlik Community

Qlik Sense App Development

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

rbdgpresales
New Contributor

Is there a way to customize rows in Pivot Table ?

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,

PNL.png

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

1 Solution

Accepted Solutions
davidganly
New Contributor III

Re: Is there a way to customize rows in Pivot Table ?

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.

  Qlik Branch

The search for the text smart.

david

4 Replies
davidganly
New Contributor III

Re: Is there a way to customize rows in Pivot Table ?

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.

  Qlik Branch

The search for the text smart.

david

rbdgpresales
New Contributor

Re: Is there a way to customize rows in Pivot Table ?

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

rbdgpresales
New Contributor

Re: Is there a way to customize rows in Pivot Table ?

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

davidganly
New Contributor III

Re: Is there a way to customize rows in Pivot Table ?

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