Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Sub totals

Dear Friends,

Following simple expression does not support with subtotals. Please help.

SUM((((INSTALLMENT*NO_INS)-AMOUNT)/NO_INS))

Rgds,

Priyantha.

1 Solution

Accepted Solutions

Re: Sub totals

Try like this

Sum(Aggr(

SUM((((INSTALLMENT*NO_INS)-AMOUNT)/NO_INS)),


Dim1, Dim2, Dim3, .....))

2 Replies

Re: Sub totals

Try like this

Sum(Aggr(

SUM((((INSTALLMENT*NO_INS)-AMOUNT)/NO_INS)),


Dim1, Dim2, Dim3, .....))

Not applicable

Re: Sub totals

Thnx Sunny...