Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Format tabla pivot

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

tablapivot2.JPG.jpg

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.

Community Browser