Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
what is your required format ?
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.
Hi Supriya,
For this I use the extension amCombo (with aggr function in dimension formula). You find the extension in Qlik Branch.
Magdalena