5 Replies Latest reply: Oct 17, 2018 6:17 AM by Andrei-Dragos Delta

# Displaying % symbol with the numbers in qliksense

Hi all,

I have a calculation in the line chart as given below.

Sum(Survey participants)/Sum(Total Participants) * 100.

I want to display the result along with the % sign in the line chart.

Example: If the result of the above calculation is 90, then it is should display 90%. How can I do this?

Thanks,

Anusha

• ###### Re: Displaying % symbol with the numbers in qliksense

Remove the part "* 100" and go to Edit > Data > Your Measure > Number Formatiing > Number > 12%

• ###### Re: Displaying % symbol with the numbers in qliksense

Hi Ivan,

I know this. But I cannot do it because I want to display both the percentages and numbers(without percentage).

I have used qsvariable extension. when I select % from the drop down, the line chart should display the results with %. When I sleect numbers from the drop down line chart should display only numbers

• ###### Re: Displaying % symbol with the numbers in qliksense

Okay, but this is not what you asked in your initial post. Please for future posts provide the full requirements.

Anyway, you can use NUM as already suggested below.

• ###### Re: Displaying % symbol with the numbers in qliksense

Hi ,

Try the below code:

num((Sum(Survey participants)/Sum(Total Participants) * 100), '#,##0%')

Or

Use only Sum(Survey participants)/Sum(Total Participants)  in the expression and on the measure field set the below formatting :

Number formatting --> Number

Formatting--> Simple--> 12%

Hope this helps...

Regards

SB

• ###### Re: Displaying % symbol with the numbers in qliksense

Hi Anusha,

a) Way1:

Sum(Survey participants)/Sum(Total Participants)

In Expression Property Number format set as %.

b)Way2:

num((Sum(Survey participants)/Sum(Total Participants) ), '##,###.0%')

Thanks,

Arvind Patil

• ###### Re: Displaying % symbol with the numbers in qliksense

hi,

you use the expression like this: Sum(Survey participants)/Sum(Total Participants)

then go to number formatting and choose one of 12%, 12.X% or 12.XX% options.

hope it helps,

Andrei.