Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


1 Reply
MK9885
Master II
Master II

You can check this link

Dynamic formatting of a bar chart