Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bimartingo
Contributor III
Contributor III

Pivot Table with Expression needing different formating

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 1column 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

1 Reply
Carlos_Reyes
Partner - Specialist
Partner - Specialist

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