
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Remove the part "* 100" and go to Edit > Data > Your Measure > Number Formatiing > Number > 12%

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
