Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.