topic Re: How to rename pivot table expression value? in QlikView

How to rename pivot table expression value?

Wed, 04 Mar 2015 11:07:02 GMT

Hi,

I have expression as below in pivot table

=IF(MIXMATCH([Support],'Client','Sales','Out','In','Expired'),[Support])

I want 'Out' labelled as 'Deleted' in Pivot table. Is it possible.

I need the pivot table shown as below on screen

Location   Client   Sales   Deleted In   Expired
a                 20       10       1             23    245
B                67       34       56           89    100
C                23       90       78           12    108

Please can anyone suggest me how to set this.

Thanks.

Re: How to rename pivot table expression value?

AbhijitBansode — Wed, 04 Mar 2015 11:13:06 GMT

sum({<Support={'Client'}>}YourMeasure) - Lable as Client

sum({<Support={'Sales'}>}YourMeasure) - Lable as Sales

sum({<Support={'Out'}>}YourMeasure) - Lable as Deleted

similar for other..

Re: How to rename pivot table expression value?

Anonymous — Wed, 04 Mar 2015 11:16:04 GMT

Try this as calculated dimension and check supress null values.

=Pick(MixMatch(Support, 'Client','Sales','Out','In','Expired'), 'Client','Sales','Deleted','In','Expired')

Marc.

Re: How to rename pivot table expression value?

Wed, 04 Mar 2015 11:19:31 GMT

Thanks. sorry typo mistake. the below I have is dimension not expression

Dimension

=IF(MIXMATCH([Support],'Client','Sales','Out','In','Expired'),[Support])

the expression I have is common expression as below

expression

=COUNT({<Support-= {' '}>}DISTINCT CustomerID)

how can I change please help.

Re: How to rename pivot table expression value?

Wed, 04 Mar 2015 11:29:53 GMT

Thanks. That's working.