topic Re: Pivot table total in QlikView

Pivot table total

priyarane — Thu, 23 Apr 2015 08:29:02 GMT

Hi Experts,

I wanted to remove particular amount from Total in pivot table;

Attached my Qvw and requirement.

kristoferahlin — Thu, 23 Apr 2015 08:45:23 GMT

Hi Priya,

Please check if the attached solution meets your requirements.

Regards,

Kristofer

jpenuliar — Thu, 23 Apr 2015 08:48:17 GMT

use this expression:

sum({<[Standard.Sub-Item1]={'*'}-{'Off-balance sheet securitization exposures'}>}[Standard.PQ 2])

jsanchezh — Thu, 23 Apr 2015 08:49:33 GMT

try with this expression:

sum({<[Standard.Sub-Item1]-={'Off-balance sheet securitization exposures'}>}[Standard.PQ 2])

Kind regards

jagan — Thu, 23 Apr 2015 08:51:23 GMT

Hi,

Try this expression

If(RowNo() = 0, sum({<[Standard.Sub-Item1]-={'Off-balance sheet securitization exposures'}>}[Standard.PQ 2]), sum([Standard.PQ 2]))

Regards,

Jagan.

priyarane — Thu, 23 Apr 2015 10:11:40 GMT

Hi Jagan,

Can you please brief of the expression,

what is Rowno() here.

jsanchezh — Thu, 23 Apr 2015 10:14:04 GMT

I think Rowno()=0 is the total line from the pivot table

jagan — Fri, 24 Apr 2015 07:31:12 GMT

Hi Priya,

For Total row the Rowno() returns 0, in this case we are using different expression.

Regards,

jagan.