Changing the numeric values to text in Pivot

[karandeep]

Hi there, 

I have created a Pivot table in Qlik where a column contains values of 0 and 1, which I have counted into two separate columns. However, I would like to display '0' as 'No' and '1' as 'Yes'. Is there a way to convert numeric values into text within the Pivot table? Many thanks.

[marcus_sommer · Accepted solution]

You could use a calculated dimension with: pick(MyField + 1, 'No', 'Yes') respectively moving this logic into the data-model and/or creating a dual(), like: dual(pick(MyField + 1, 'No', 'Yes'), MyField) as MyField

[Kelliesy]

Can you use this in the field logic?  if(yourcolumname = 0, 'N', 'Y')  ?

[QFabian · Accepted solution]

Hi @karandeep Instead of replace or convert your field, you should create a new field, using @marcus_sommer  or @Kelliesy suggerences