Qliksense table with number and percentage together

[richard24best]

Hi All,

I have a requirement to show both number and percentage values in a cell instead of different columns or table.

Is it possible in Qliksense?

Please check and advice. Attaching screenshot what I would require.

Thanks,

Richard

[Prashant_Naik]

Hi Richard,

Yes you can do this by concatenating the two expression using &' '& sign and formatting the expression using Num() function shown below.

Num(Sum(Sales),'####0')&' '&Num(Sum(Sales)/Sum(total Sales),'##0%')

Hope this helps!!

Regards,

Prashant.

[richard24best]

Hi Prashant,

Thank you for prompt support.

Well I tried to use my expression as suggestion but its showing me only percentage value -

Num(Count([CTMP Trade Side ID]),'####0')&''& Num(Count([CTMP Trade Side ID])/Count(Total[CTMP Trade Side ID]),'##0%')

Please let me know if I am missing something from below dimensions or measures.

My dimensions are [Touched],[Country] and [Reason] and measure is to count ([CTMP Trade Side ID])

Thanks,

Richard

[richard24best · Accepted solution]

Hi Prashanth, Thanks for confirming its possible and giving idea.

I was able to figure out with some changes and it works perfect now -

(Count([CTMP Trade Side ID])&'('&(round(count([CTMP Trade Side ID])/count(Total <[CTMP Joint Touch Statement]>[CTMP Trade Side ID]),0.0001))*100 &'%'&')')

Regards,

Richard