Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerald_lebret
Partner - Creator
Partner - Creator

Style format template for P&L pivot Qlik Sense

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.

Labels (3)
2 Replies
Anil_Babu_Samineni

Perhaps create one island table with

Load * Inline [

Dim

1

2

];

And then, create table using

CrossTable(Data, Sales, 1)

Load * Inline [

Data, Sales A, Sales B, Sales C

.............

];

Dimension : Pick(Dim, Sales, 'Total Sales')

Expression : Pick(Dim, Sum(Data), Sum(Sales))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
gerald_lebret
Partner - Creator
Partner - Creator
Author

Hello all,
I found a work around but since I can only have one dimension, I have to create my total within the script.

However, by doing that, I cannot play with filters.

Anyone has an idea?

 

Thank you.