Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stanlyrj
New Contributor III

Calculating total lines in P&L Reporting

Hi Community,

Here I'm trying to calculate Total lines from a P&L table.

The below given is the structure of my P&L table.

P&L.PNG

I have tried using aggr() and sum().

Can anyone suggest me any expression to solve this issue?

Thanks in advance.

Regards,

Stan

Tags (2)
1 Reply

Re: Calculating total lines in P&L Reporting

use recNo() while loading data

then use max(recNo) to get total no of rows in table

or

add 1 as flag in load script

and use sum(flag) to get total no of rows.

Regards,

Regards,
Prashant Sangle
Community Browser