Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Khan_Mohammed
Not applicable

Re: Dynamically Convert Number to percentage in qlik sense

You can check this link

Dynamic formatting of a bar chart