how to show percentage below numbers in bracket in single measure in pivot table in qliksense

[indra]

how to show percentage below numbers in bracket in single measure in pivot table in qliksense

[sbaro_bd]

Hi @indra ,

Try something like this  : [Measure1] & '(' & [Measure2] & ')'.

Regards.

[indra]

I already used same expression, but not working in pivot table

[MatheusC]

Use the dual function, it can combine values ​​for you, the function is based on dual(text,number).

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FormattingFunct....

The expression below, I leave it just as an example, assign it according to your data

=dual(round(sum(Sales)/sum(total Sales)*100) & '%' & ' ( ' & round(sum(Sales)/1000) &
')',sum(Sales)/1000)

example result:

- Regards, Matheus

[sbaro_bd]

I just try the same expression in a pivot table and it works perfectly.

Can you show us the result when you use this kind of expression ?

Regards.

[indra]

Hi, I need to show the below screenshot data in percentage below bracket numbers. Please see the atachment

[indra]

Hi, any idea for the above one in pivot table?

[MatheusC]

You won't be able to do this line break in a standard way, maybe some extension or change with CSS, but I'm not sure. I found this solution so I could test it and see if it would work for you.

Add the following in the CSS with Multi KPI:
div.value.ng-binding.ng-scope {
white-space: pre !important;
}

In the expression for newlines with chr(10) :
=Measure1 & chr(10)&
Measure2

- Matheus

[seanbruton]

This is the solution i would use

[indra]

Hi Mathe, In pivot table that solution is not working for me.