Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator
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)
1 Reply
Highlighted
Master
Master