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

Is there a way to customize rows in Pivot Table ?

rbdgpresales — Thu, 01 Dec 2016 07:15:19 GMT

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

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

davidganly — Thu, 01 Dec 2016 19:56:41 GMT

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

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

rbdgpresales — Thu, 01 Dec 2016 23:48:18 GMT

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

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

rbdgpresales — Mon, 05 Dec 2016 00:21:02 GMT

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

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

davidganly — Mon, 05 Dec 2016 09:23:34 GMT

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