Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fmazzarelli
Contributor III

pick

Hi Community,

i create a table

Immagine.png

how to replace the column names with the values ​​shown in the legend


Fabio M

2 Replies
ogster1974
Honored Contributor II

Re: pick

Labels on pivots cannot be dynamically set yet.  You would need to replace the filed names 1,2,3,4 with (Presa, Tratta etc...) in your data load.

brunobertels
Valued Contributor

Re: pick

Hi Fabio

It seems you have a dimension called "TipoCosti" with the fallowing values 1, 2, 3 , 4 that's representing Presa, Tratta etc

You can add this in the script like that :

Load

TipoCosti,

If(Tipocosti='1','Presa',

if (TipoCosti='2','Tratta',

if (TipoCosti='3','Distribuzione',

if (TipoCosti='4','Passiaggio a Magazzino',)))) as "TipoCostiLabel",

So it will add you a new dimension called TipoCostiLabel in your data

Replace TipoCosti with this new dimension TipoCostiLabel so you will see the text value rather than 1 or 2 etc

Hope it' helps,

Bruno