Format tabla pivot

Tue, 19 Nov 2013 20:45:54 GMT

Hi fellows, this a simple example of how I want to display the data:

the expression is set to INTEGER with format #.##0.

I want to "Dimension2" with value "US$" the expression is displayed with 2 decimal places('##0,00'), value "Year" without format and

the rest with format numeric without decimals.

Try on EXPRESSIONS / TEXT FORMAT / DEFINITION ---> = if (Dimension2 = 'US$', Num# (expression, '# # 0,00 "))

but does not work because I think there just takes bold, italic, etc, etc and not the formats numeric.

thanks any help, and sorry my english.

\m/

P.L.

topic Format tabla pivot in QlikView