# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for
Did you mean:
Highlighted Creator

## P&L pivoting

Good Day,

Situation:

I have a dimension called 'Category', This dimensen is structured trough an Excel file.

For example;

Accountnumber                             Category

700003                                                OMZET

700103                                                OMZET

720003                                                FIN

720003                                                FIN

And so on, so if I put Category as a dimension in a pivot table, there is no problem at all.

But I want to do calculations based on the typ of category.

For example:

OMZET - FIN

And display this in the same table.

The calculation for all categories is :

if(sum(GLE15_CR) > sum(GLE15_DB), sum(GLE15_CR) - sum(GLE15_DB)) &' '& if(sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) -sum(GLE15_CR))

Now how do I do This so that every category is a seperate Line in a P&L pivot and I can do the calcualtions depending on if statements lik:

if(Category = 'OMZET', sum(GLE15_CR) > sum(GLE15_DB), sum(GLE15_CR) - sum(GLE15_DB)) &' '& if(Category = 'OMZET',sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) -sum(GLE15_CR))

/

if(Category = 'FIN', sum(GLE15_CR) > sum(GLE15_DB), sum(GLE15_CR) - sum(GLE15_DB)) &' '& if(Category = 'FIN',sum(GLE15_DB) > sum(GLE15_CR), sum(GLE15_DB) -sum(GLE15_CR))

Is there a way to do this, perhaps with master items and stuff?

Also how does the excel template system work for the P&L system, I can't find concrete examples or instructions.

Thanks a bunch!

DC

Labels (3)

• ### P&L pivot  