Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to rename pivot table expression value?


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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Try this as calculated dimension and check supress null values.

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

Marc.

View solution in original post

4 Replies
AbhijitBansode
Specialist
Specialist

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

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

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

similar for other..

Anonymous
Not applicable
Author

Try this as calculated dimension and check supress null values.

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

Marc.

Not applicable
Author

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.

Not applicable
Author

Thanks. That's working.