Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

aleix_rodriguez
New Contributor

P&L percentages

Hello,

I've built a P&L table using a Simple Table. The result is the one that follows:

LevelAccount NameAmountPercentage
100Revenue100.000100%
200Cost of sales- 75.000- 75%
300Gross Profit- 25.000- 25%

I want to calculate the column "Percentage" but I don't know how to manage with it.

I tried to use the following expression but it did't work: sum(Amount) / sum(total <Level> if(Level=100, Amount))

Can somebody help me?

Thanks in advance.

Regards,

1 Reply

Re: P&L percentages

Create a variable vRevenue as =sum({<Level={100}>}Amount). Then use the variable in your expression: sum(Amount)/$(vRevenue)


talk is cheap, supply exceeds demand
Community Browser