# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted Contributor II

## pivot table expression

Hi,

Basically I am working on a pivot table. Can anyone help me to solve the following equation? it would very much be appreciated.

 Number of reference « pooling Pxxx» : Number of [Ref. Pooling] starting with P***
 Number of reference « Mono Mxxx» : Number of [Ref. Pooling] starting with M*** or
Number of [Ref. Pooling] with [Code raison] « camion « mono-industriel »
 Pooling rate (camions théoriques) = Number of [Ref. Pooling] starting with P*** / total
Number of reference (« pooling Pxxx + Mono Mxxx ») Labels (2)

• ### Pivot Tables

1 Solution

Accepted Solutions
Highlighted Contributor III

## Re: pivot table expression

Hi,

For number 1 and 2 can done by this dimension. and tick 'Suppress When Value is Null' in the same tab.

=IF(LEFT([Ref. Pooling],1)='M','MXXX',
IF(LEFT([Ref. Pooling],1)='P','PXXX'))

For number 3, go to Presentation tab, Tick 'Show Partial Sums'

For the expression, put COUNT(DISTINCT [Ref. Pooling])

Thanks.

3 Replies
Highlighted Contributor III

## Re: pivot table expression

Hi, I'm not very understand about your requirement but I hope below helps.

=IF(LEFT([No Of Reference],1)='M','MXXX',
IF(LEFT([No Of Reference],1)='P','PXXX',
[No Of Reference]))

For Expression, put COUNT(DISTINCT [No Of Reference])

Thanks.

Jeff

Highlighted Contributor II

## Re: pivot table expression

Hi jefwork,

the following are the ones I need to be solved.

1.Number of [Ref. Pooling] starting with P***

2.Number of [Ref. Pooling] starting with M***

3.Number of [Ref. Pooling] starting with P*** / total
Number of reference (Number of [Ref. Pooling] starting with P*** + Number of [Ref. Pooling] starting with M***) Highlighted Contributor III

## Re: pivot table expression

Hi,

For number 1 and 2 can done by this dimension. and tick 'Suppress When Value is Null' in the same tab.

=IF(LEFT([Ref. Pooling],1)='M','MXXX',
IF(LEFT([Ref. Pooling],1)='P','PXXX'))

For number 3, go to Presentation tab, Tick 'Show Partial Sums'

For the expression, put COUNT(DISTINCT [Ref. Pooling])

Thanks.