Hide Expression In Pivot Column Using Calculated Dimension

Anonymous — Tue, 23 Feb 2016 17:44:22 GMT

Hi,

I have a pivot table that uses a calculated dimension, used as a column, defined as:-

Pick(
(
IF(aggr(sum({[Leakage]<

[Wholesaler Type (Wk)]={'Third Party Wholesaler'}, [Transactions.Transaction Effective Month Year]={'<=$(=vLeakageTablePYEnd) >=$(=vLeakageTablePYStart)'}>}[GWP excl IPT]), [Client Name])

> 0,1,0)

+IF(aggr(sum({[Leakage]<

[Wholesaler Type (Wk)]={'Third Party Wholesaler'}, [Transactions.Transaction Effective Month Year]=p([Transactions.Transaction Effective Month Year])>}[GWP excl IPT]), [Client Name])

> 0,2,0)

+IF(aggr(sum({[Leakage]<

[Wholesaler Type (Wk)]={'*'}-{'Third Party Wholesaler'}, [Transactions.Transaction Effective Month Year]=p([Transactions.Transaction Effective Month Year])>}[GWP excl IPT]), [Client Name])

> 0,4,0)
) + 1,

'5. n/a',
'1. lost',
'4. new',
'2. renewed',
'5. n/a',
'3. moved',
'4. new',
'2. renewed')

I then have a couple of expressions and want to hide (or set as null() if unable to hide) when the dimension value is '4. new' the expression is

SUM({[Leakage]<[Transactions.Transaction Effective Month Year]=p({Leakage}[Transactions.Transaction Effective Month Year]), [Wholesaler Type (Wk)]={'Third Party Wholesaler'}>}[GWP excl IPT])

I've tried various combinations of trying to put a conditional in the expression but to no avail!

Thanks, Robert

topic Hide Expression In Pivot Column Using Calculated Dimension in QlikView

Hide Expression In Pivot Column Using Calculated Dimension