topic Re: Changing the numeric values to text in Pivot in App Development

Changing the numeric values to text in Pivot

karandeep — Fri, 23 May 2025 09:35:00 GMT

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.

Re: Changing the numeric values to text in Pivot

marcus_sommer — Fri, 23 May 2025 13:22:55 GMT

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

Re: Changing the numeric values to text in Pivot

Kelliesy — Fri, 23 May 2025 13:25:26 GMT

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

Re: Changing the numeric values to text in Pivot

QFabian — Fri, 23 May 2025 13:32:49 GMT

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