Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
In straight table for value of usage dimension I have some negative values.
these values I have to represent in bracket with red color like below.
Please help me on this.
Thanks in advance.
Go to Solution.
Can you try something like this
Suppose A is the field or Expression Then
for the color you can use text color option:
You can do a Calculated dimension using the Fabs() function. This function converts the negative values to positive.
Thanks for your reply .
Its converting negative to positive but that negative conversion values need to show like (93.27) by highlighting in red font.
Use below expression.
For Convert Positive Value:
For Changing color: (Please click the expression tab and select the text color add below expression
You can do that by using format pattern on chart measure settings.
Yeah, I would follow Kaan's approach rather than using the absolute value function fab().