Pivot Table with Expression needing different formating

bimartingo — Mon, 11 Nov 2013 21:00:56 GMT

Hi Folks,

i want to build a pivot table with to dimensions (one for line and one for column) and only one expression wich format changes depending on the line dimension. I tried to use the Num() Function in the expression, like this:

Expression: = if([line]='a value'

, num( [value] , '#,##0') //case when [line]='a value'

, num( [value] , ##0,00%') //otherwise

)

The problem is that depending on the filter (selected values of other fields) , the presented value does not respect the formating.

Ex:

[line]	[column]
	column value 1	column value 2
a value	345456.60%	34.500
b value	12.90%	130.01%

As you can see, for column value 1 and a value data is presented as percentage and for column value 2, it's presented as expected.

is there a work around? The number format for expressions on parameters windows do not allow multiple formats and the default option (no specific formating) results in this.

Thank you for any help

Re: Pivot Table with Expression needing different formating

Carlos_Reyes — Tue, 12 Nov 2013 21:21:59 GMT

Mmmm... I can't replicate your problem. Please review the attached.

topic Re: Pivot Table with Expression needing different formating in QlikView

Pivot Table with Expression needing different formating

Re: Pivot Table with Expression needing different formating