
Not applicable
2016-09-19
06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dynamically Convert Number to percentage in qlik sense
is there a way of dynamically changing a format of a bar chart depending on its values....
some rows of data are for percentages
KPI=
1)Attaintment in 75%
2)Sales in 1008 number value
when user select Attainment bar should be in % when user selects sales it should be number
i tried using the option
=NUM( (sum(sales)/Sum(target))*100, '##.##%','.',',')
also tried
=NUM( (sum(sales)/Sum(target)), '##,00%',',','.')
or
= values &'%'
same expression in working in text box but not working in line chart. i have set the formatting to 'AUTO'.
Please suggest an option to fix the issue
2,418 Views
1 Reply

Master II
2016-09-19
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can check this link
2,179 Views
