Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
robertjamesrigg
Contributor
Contributor

Hide Expression In Pivot Column Using Calculated Dimension

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


0 Replies