Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Renaming field values in a pivot table

Hi -

Is there a way to change the value of the field in a pivot table and table box?

For example:

Field 1 Value ----- Replace Value     

Hot

Cold

Uknown -------------> Green

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

Something like

if(wildmatch(Field,'*Unknown*'),'Green')

View solution in original post

6 Replies
sivarajs
Specialist II
Specialist II

Something like

if(wildmatch(Field,'*Unknown*'),'Green')

Not applicable
Author

This formula works perfectly in a pivot table!

Now i need to apply the same formula as part of my pie chart. Is that possible?

The formula that i am using right now to calculate values as follows:

Color as my dimension and Fabs(Sum([GL Amount]))/100

Please help!

Thanks

Not applicable
Author

Another question how can i hide certain field values. For example if i waned to hide values for Pink but show everything else?

Thanks

sivarajs
Specialist II
Specialist II

you just null the particular value

if(wildmatch(Field,'*Unknown*'),null(),Field)

Not applicable
Author

what about this one?

This formula works perfectly in a pivot table!

Now i need to apply the same formula as part of my pie chart. Is that possible?

The formula that i am using right now to calculate values as follows:

Color as my dimension and Fabs(Sum([GL Amount]))/100

Please help!

sivarajs
Specialist II
Specialist II

Pie chart has dimension and expression so yes can use the same in that as well