P&L pivoting

[dries_clairhout]

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

[beck_bakytbek]

Hi Dries,

check this: 

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

i hope that helps