how to show 0% and 100% values for line chart in Qlikview

[bvssudhakar]

Hi Experts,

I have created line chart with following expressions

1. =num((Sum([Total release wise UAT Defects])/Sum([DefectList.No.of Iterations]))*100,'#,##')&'%'

2. =num((Sum([DefectList.No.of Iterations])-Sum([Total release wise UAT Defects]))/num(Sum([DefectList.No.of Iterations]),'###0')*100,'##,##')&'%'

it is giving output correctly. but it's not showing 0%'s and 100%'s Values in my line chart. how to show them also

This is what i created chart

[dplr-rn]

Set the format for both expressions as 'Show in percent' in number tab .

you may need to modify the expression to remove formatting there

that should result in your axis showing %.

if you want to make it default from 0-100% use static min and static max in Axes tab