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: 
Not applicable

Conditional Number Format

Hi everyone - I have a pivot table that contains different data types which need to be formated based on the dimension.

For example, I have financial data mixed with non-financial data:

Measure, Value
Revenue, $1202.00
Units, 45

I didn't see a way in the chart properties to conditionally format something based on its dimension. The Number tab just allows you to override the format but if() statements don't work.

Does anyone know how this can be achieved in a pivot table chart?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

You can define format directly in expression for value, something like this:
if(condition, num(Value, 'format1'), money(Value, 'format2'))
On the Nimber tab, use "expression default".

View solution in original post

1 Reply
Anonymous
Not applicable
Author

You can define format directly in expression for value, something like this:
if(condition, num(Value, 'format1'), money(Value, 'format2'))
On the Nimber tab, use "expression default".