article Style format template for P&L pivot Qlik Sense in Member Articles

Style format template for P&L pivot Qlik Sense

gerald_lebret — Wed, 21 Sep 2022 17:07:35 GMT

Hello,

I am trying to use the new P&L Pivot table function in Qlik Sense.

It works great except that I would like to create a style format template and I can't manage to do what I want.

How am I suppose to create the subtotals?
For instance, I've got the following account in my data:

Sales A
Sales B
Sales C

I would like my table to look like this:

Sales (which is just a title)
   Sales A
   Sales B
   Sales C
Total Sales

Thus, How is Qlik Going to understand that it must link my 3 sales accounts to the sales titles, the sales subtotals and also understand that total sales is the sum of sales A+B+C?

Thank you for your help.

Re: Style format template for P&L pivot Qlik Sense

Sue_Macaluso — Thu, 22 Aug 2019 15:40:29 GMT

@gerald_lebret Hi Gerald, You posted this in QlikView documents and it appears to be a question. I have a feeling because it's in the document section and not the discussion is why many might not be seeing this. If you still have this question I would cut and paste this into a QlikView discussion. https://community.qlik.com/t5/New-to-QlikView/bd-p/new-to-qlikview

Re: Style format template for P&L pivot Qlik Sense

gerald_lebret — Thu, 29 Aug 2019 14:26:51 GMT

@Sue_MacalusoHI Sue, I just saw your answer. Thank you for that. I just posted that to the question page.

Thank you.