Changing number formatting for each dimension field value

[srujanaponnuru]

Hi,

I have a field called Trip and the values are:

Trip

ABC,

123,

xyz,

etc

i have pulled Trip field as a dimension in a straight tbale in qliksense.

and i have written few measures like sum(Sales)

But now for each dimension value for example i need ABC in % format and 123 in number format.....

Please help to achieve this

[QFabian]

Hi @srujanaponnuru , try this for expression :

num(sum(1),if(Trip = 'ABC','#.##0','#.##0%'))

And set 'measure expression' as number formatting :