Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
bvssudhakar
Creator III
Creator III

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

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

Capture.JPG

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

ExpressionTab:

Exp1:

=(Sum([Total release wise UAT Defects])/Sum([DefectList.No.of Iterations]))

Exp2:

=(Sum([DefectList.No.of Iterations])-Sum([Total release wise UAT Defects]))/(Sum([DefectList.No.of Iterations]))

PresentationTab:

Uncheck Supress Zero Values

check Zero on Bar

NumbersTab:

Fixed to 2 Decimals

check show in Percent

View solution in original post

10 Replies
Frank_Hartmann
Master II
Master II

please share qvw!

bvssudhakar
Creator III
Creator III
Author

Hi Frank,

Here i attached qvw please have a look and give the possible solution

Thank you in advance

Frank_Hartmann
Master II
Master II

not sure if i understood your requirement correctly,

but have a look at the attached qvw

bvssudhakar
Creator III
Creator III
Author

Hi Frank,

I am using Personal edition. Can please write here what you have changed in the chart

Thank you in advance

Frank_Hartmann
Master II
Master II

is this what you want to achieve?

Unbenannt.png

bvssudhakar
Creator III
Creator III
Author

Hi Frank,

Yeah i need like this and as well as i want to show 0%'s also

Can you please how you implemented it

Frank_Hartmann
Master II
Master II

ExpressionTab:

Exp1:

=(Sum([Total release wise UAT Defects])/Sum([DefectList.No.of Iterations]))

Exp2:

=(Sum([DefectList.No.of Iterations])-Sum([Total release wise UAT Defects]))/(Sum([DefectList.No.of Iterations]))

PresentationTab:

Uncheck Supress Zero Values

check Zero on Bar

NumbersTab:

Fixed to 2 Decimals

check show in Percent

bvssudhakar
Creator III
Creator III
Author

Hi Frank,

I have used same thing. it's some thing better but it is showing above 100 percents also why?? can you please suggest for that also

Frank_Hartmann
Master II
Master II

i cant see any values above 100%

Unbenannt.png