Bar Graph:Not able to show both percentage and number

[berryandcherry6]

Hi,

i have a graph in qliksense where i want to show both number and percentage in the graph. But it always displays sum number. i want to show  

value data points in this format

45(23%)

script code:

Table:

Load * inline

[Type,campaign,sum

Deliverd,c1,34

Deliverd,c2,4

Deliverd,c3,56

Opened,c3,23

Opened,c1,20

Opened,c2,5

CTR,c1,45

CTR,c2,12

CTR,c3,15

];

FinalData:

Load

Type,

campaign,

sum,

dual(sum & ' (' & num(sum/2,'0%') & ')', sum) as dual_data

Resident Table;

drop Table Table;

But using above i am not able to display in required format.

How to do this? Please help me on this.

[arulsettu]

what is your required format ?

[berryandcherry6]

Hi,

My required format is  48(24%)

here 48 is total sum and 24% is  sum/2

i have used

dual(sum & ' (' & num(sum/2,'0%') & ')', sum) as dual_data

in my script. To display in 48(24%) format it is not at all displaying like required.

[magdalenatudose]

Hi Supriya,

For this I use the extension amCombo (with aggr function in dimension formula). You find the extension in Qlik Branch.

Magdalena