Displaying % symbol with the numbers in qliksense

[anuhegde]

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

[Ivan_Bozov]

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

[anuhegde]

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

[sudhakar_budde]

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

[Ivan_Bozov]

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.

[arvind_patil]

Hi Anusha,

Add Normal Expression into chart.

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

[andrei_delta]

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.