Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
mshailaja
Contributor III
Contributor III

need help urgent

Hi i have 3 column names -NAme, Measurement, Threshold ( all 3 columns are coming directly from the database).If the Outcome is pass means(Measurement>Threhold)

Out come is fail means(Measurement < Threshold)

The above Outcome field also directly coming form the database

NOw i want 2 line charts Average of Measurement and Average of Threshold Based on Name

I have already created 2 lline charts

But i need inn percetage both on x axes and also in Linecharts

Dimension as Name

i have taken expression as Avg(Measurement) and one more expression as AVG(MID(THRESHOLD,3,len(THRESHOLD)-3))

i dnt know whether i have given correct calculation ( the two expressions), user wants to see percentage in x axes

and also in  charts % format he need and alos he need only two decimals

Can anyone please help me

NAme  Measurement Threshold Outcome  

A>= 90 %100PASS
A>= 97 %100PASS
A>= 98 %100PASS
A>= 90 %100PASS
A>= 97 %100PASS
A>= 98 %100PASS
A>= 90 %100PASS
A>= 97 %100PASS
A>= 98 %100PASS
A>= 90 %100PASS
A>= 97 %100PASS
AD>= 99.5 %100PASS
AD>= 97 %99.94623655914PASS
AD>= 97 %99.963112005366PASS
AD>= 98 %99.963112005366PASS
AD>= 90 %96.296296296296PASS
AD>= 90 %100PASS
AD>= 97 %100PASS
AD>= 98 %100PASS
AD>= 90 %96.153846153846PASS
AD>= 97 %98.885350318471PASS
AD>= 98 %98.885350318471PASS
AD>= 90 %100PASS
AD>= 97 %100PASS
AD>= 98 %100PASS
AD>= 90 %96.153846153846PASS
AD>= 97 %98.339438339438PASS
AD>= 97 %99.929792429792PASS
BC>= 98 %97.317554240631FAIL
BC>= 98.5 %97.094017094017FAIL
BC>= 90 %100PASS
BC>= 97 %100PASS
BC>= 98.5 %100PASS
BC>= 98 %100PASS
BC>= 90 %100PASS
BC>= 97 %100PASS
BC>= 98 %100PASS
BC>= 90 %100PASS
BC>= 97 %100PASS
BC>= 98 %100PASS
BC>= 98 %99.883512544803PASS
BC>= 90 %100PASS
BC>= 97 %100PASS
BC>= 98 %100PASS
BC>= 90 %100PASS
BC>= 97 %100PASS
BC>= 98 %100PASS
AAC>= 98.5 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 98.5 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 97 %99.199014171288PASS
AAC>= 97 %99.812423124231PASS
AAC>= 98 %98.662551440329PASS
AAC>= 98 %99.199014171288PASS
AAC>= 98 %99.674145299145PASS
AAC>= 98 %99.720695970696PASS
AAC>= 98 %99.812423124231PASS
AAC>= 90 %96.153846153846PASS
AAC>= 98 %99.748168498168PASS
AAC>= 97 %99.514348785872PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98.5 %100PASS
AAC>= 98 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 99.5 %100PASS
AAC>= 90 %93.333333333333PASS
AAC>= 90 %96.774193548387PASS
AAC>= 97 %99.152542372881PASS
AAC>= 97 %99.550653594771PASS
AAC>= 98 %99.152542372881PASS
AAC>= 98 %99.407783417936PASS
AAC>= 98 %99.491525423729PASS
AAC>= 98 %99.95337995338PASS
Cqw>= 98.5 %97.142857142857FAIL
Cqw>= 98.5 %98.285714285714FAIL
Cqw>= 98.5 %98.544973544974PASS
Cqw>= 98.5 %99.847619047619PASS
Cqw>= 98 %99.550653594771PASS
Cqw>= 98.5 %100PASS
Cqw>= 90 %100PASS
Cqw>= 97 %100PASS
Cqw>= 98 %100PASS
Cqw>= 90 %100PASS
Cqw>= 98.5 %100PASS
Cqw>= 97 %100PASS
Cqw>= 98 %100PASS
Cqw>= 98.5 %100PASS
Cqw>= 90 %100PASS
Cqw>= 97 %100PASS
Cqw>= 98 %100PASS
Cqw>= 90 %100PASS
Cqw>= 97 %100PASS
Cqw>= 98.5 %100PASS
Cqw>= 98 %100PASS
Cqw>= 90 %96PASS
AAC>= 97 %99.80372250423PASS
AAC>= 98 %99.781544256121PASS
AAC>= 98 %99.80372250423PASS
AAC>= 98 %99.892787524366PASS
AAC>= 98.5 %99.702564102564PASS
AAC>= 98.5 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 90 %100PASS
AAC>= 97 %100PASS
AAC>= 98 %100PASS
AAC>= 90 %93.333333333333PASS
AAC>= 90 %96.666666666667PASS
Cqw>= 97 %78.472222222222FAIL
EOVO>= 97 %98.194444444444PASS
saa>= 97 %98.611111111111PASS
saa>= 97 %98.782608695652PASS
saa>= 97 %99.060283687943PASS
saa>= 97 %99.166666666667PASS
saa>= 97 %99.227430555556PASS
saa>= 97 %99.229166666667PASS
saa>= 97 %99.521963824289PASS
saa>= 97 %99.602150537634PASS
saa>= 97 %99.684569479966PASS
saa>= 97 %99.760416666667PASS
saa>= 97 %99.811827956989PASS
saa>= 97 %99.833333333333PASS
saa>= 97 %99.850809889173PASS
saa>= 97 %99.85142118863PASS
saa>= 99.6 %99.166666666667PASS
saa>= 99.6 %99.610136452242PASS
saa>= 99.6 %99.647619047619PASS
saa>= 99.6 %99.833333333333PASS
saa>= 99.7 %98.782608695652PASS
saa>= 99.7 %99.021739130435PASS
saa>= 99.7 %99.096774193548PASS
Cqw>= 99.7 %99.229166666667FAIL
Cqw>= 99.7 %99.383333333333FAIL
Cqw>= 99.7 %99.555555555556FAIL
Cqw>= 99.7 %99.602150537634FAIL
saa>= 99.7 %99.708333333333PASS
saa>= 99.7 %99.760416666667PASS
saa>= 99.7 %99.811827956989PASS
saa>= 99.9 %0PASS
Cqw>= 99.9 %98.575268817204FAIL
Cqw>= 99.9 %99.060283687943FAIL
Cqw>= 99.9 %99.227430555556FAIL
Cqw>= 99.9 %99.296875FAIL
Cqw>= 99.9 %99.521963824289FAIL
Cqw>= 99.9 %99.684569479966FAIL
Cqw>= 99.9 %99.850809889173FAIL
Cqw>= 99.9 %99.85142118863FAIL
Cqw>= 90 %85FAIL
saa>= 90 %90PASS
saa>= 90 %91.304347826087PASS
saa>= 90 %93.548387096774PASS
Cqw>= 97 %74.166666666667FAIL
saa>= 97 %97.833333333333PASS
saa>= 97 %99.610136452242PASS
saa>= 97 %99.647619047619PASS
saa>= 97 %99.708333333333PASS
saa>= 99.6 %0PASS
saa>= 99.6 %98.782608695652PASS
Cqw>= 99.6 %99.383333333333FAIL
saa>= 99.6 %99.708333333333PASS
saa>= 97 %0PASS
Cqw>= 97 %0FAIL
saa>= 90 %90.322580645161PASS
saa>= 97 %99.383333333333PASS
saa>= 90 %100PASS
saa>= 99.7 %100PASS
saa>= 99.9 %100PASS
saa>= 99.6 %100PASS
saa>= 97 %100PASS
saa>= 90 %100PASS
saa>= 97 %100PASS
saa>= 99.5 %100PASS
saa>= 90 %100PASS
saa>= 97 %100PASS
saa>= 99.5 %100PASS
saa>= 70 %100PASS
saa>= 90 %100PASS
saa>= 97 %100PASS
saa>= 99.5 %100PASS
saa>= 70 %96PASS
saa>= 70 %96.666666666667PASS
saa>= 97 %99.171270718232PASS
saa>= 97 %99.652777777778PASS
saa>= 97 %99.730820995962PASS
saa>= 97 %99.873737373737PASS
saa>= 99.5 %99.583333333333PASS
saa>= 99.5 %99.932795698925PASS
saa>= 70 %100PASS
saa>= 97 %99.475308641975PASS
saa>= 99.5 %99.652777777778PASS
saa>= 99.5 %99.730820995962PASS
saa>= 97 %100PASS
saa>= 99.5 %100PASS
Cqw>= 90 %0FAIL
jkju>= 70 %100PASS
Majk>= 90 %100PASS
Majk>= 97 %100PASS
Majk>= 99.5 %100PASS
Majk>= 70 %96.666666666667PASS
Majk>= 70 %96.774193548387PASS
Majk>= 97 %99.607279693487PASS
Majk>= 97 %99.921594982079PASS
Majk>= 97 %99.930555555556PASS
Majk>= 97 %99.946164199192PASS
Majk>= 97 %99.946759259259PASS
Majk>= 99.5 %99.607279693487PASS
Majk>= 99.5 %99.921594982079PASS
Majk>= 99.5 %99.92816091954PASS
Majk>= 99.5 %99.974537037037PASS
Majk>= 99.5 %99.988425925926PASS
Majk>= 97 %100PASS
Majk>= 99.5 %99.379480286738FAIL
Majk>= 99.5 %99.930555555556PASS
Majk>= 99.5 %99.932795698925PASS
Majk>= 99.5 %99.946759259259PASS
Majk>= 99.5 %99.946164199192PASS
Majk>= 99.5 %100PASS
Majk>= 90 %100PASS
Majk>= 99.5 %100PASS
Majk>= 97 %100PASS
Majk>= 90 %100PASS
Majk>= 97 %100PASS
Majk>= 98.5 %100PASS
Majk>= 99.5 %100PASS
Majk>= 98 %100PASS
Majk>= 90 %100PASS
Majk>= 97 %100PASS
Majk>= 98.5 %100PASS
Majk>= 98 %100PASS
Majk>= 90 %96.875PASS
Majk>= 97 %98.840287124271FAIL
Majk>= 97 %99.193548387097FAIL
Majk>= 97 %99.907407407407PASS
Majk>= 99.5 %99.327052489906FAIL
Majk>= 99.5 %99.907407407407PASS
Majk>= 90 %96.774193548387PASS
Majk>= 90 %100PASS
Majk>= 97 %100PASS
Majk>= 99.5 %100PASS
Majk>= 99.8 %98.891843971631FAIL
Majk>= 99.8 %100PASS
Majk>= 90 %100PASS
Majk>= 99.5 %100PASS
Majk>= 90 %93.548387096774PASS
Majk>= 97 %98.308243727599PASS
Majk>= 99.9 %99.888888888889FAIL
Majk>= 90 %100PASS
Majk>= 99.9 %100PASS
Majk>= 97 %100PASS
Cqw>= 90 %75FAIL
Cqw>= 90 %80.769230769231FAIL
Cqw>= 90 %83.333333333333FAIL
Cqw>= 90 %84.615384615385FAIL
Cqw>= 90 %85.714285714286FAIL
Cqw>= 90 %87.096774193548FAIL
Cqw>= 90 %88.888888888889FAIL
Cqw>= 90 %90PASS
Cqw>= 90 %92.592592592593PASS
Cqw>= 90 %96.153846153846PASS
Cqw>= 90 %96.296296296296PASS
Cqw>= 90 %96.428571428571PASS
Cqw>= 90 %96.551724137931PASS
Cqw>= 97 %96.823406478579FAIL
Cqw>= 97 %96.858740578653FAIL
Majk>= 97 %97.728377065112PASS
Majk>= 97 %97.967711301045PASS
Majk>= 97 %98.103038936372PASS
Majk>= 97 %98.765067650677PASS
Majk>= 97 %98.962441314554PASS
Majk>= 97 %99.043927648579PASS
Majk>= 97 %99.328908554572PASS
Majk>= 97 %99.416484318016PASS
Majk>= 97 %99.511737089202PASS
Majk>= 97 %99.518779342723PASS
Majk>= 97 %99.79093258163PASS
Majk>= 97 %99.842079689018PASS
Majk>= 97 %99.852696602518PASS
Majk>= 97 %99.894296951819PASS
Majk>= 97 %99.917840375587PASS
Majk>= 97 %99.961986220005PASS
Majk>= 97 %99.96475327291PASS
Cqw>= 99.9 %75FAIL
Cqw>= 99.9 %80.769230769231FAIL
Cqw>= 99.9 %83.333333333333FAIL
Cqw>= 99.9 %87.096774193548FAIL
asd>= 99.9 %88.888888888889FAIL
asd>= 99.9 %90FAIL
aswe>= 99.9 %92.307692307692FAIL
Cqw12>= 99.9 %92.592592592593FAIL
Cqw12>= 99.9 %92.857142857143FAIL
Cqw12>= 99.9 %93.333333333333FAIL
Cqw12>= 99.9 %96.551724137931FAIL
Cqw12>= 99.9 %96.774193548387FAIL
Cqw12>= 99.9 %96.815286624204FAIL
Cqw12>= 99.9 %96.823406478579FAIL
Cqw12>= 99.9 %97FAIL
Cqw12>= 99.9 %98.729782369379FAIL
Cqw12>= 99.9 %98.765067650677FAIL
Cqw12>= 99.9 %98.819188191882FAIL
Cqw12>= 99.9 %98.962441314554FAIL
Cqw12>= 99.9 %99.043927648579FAIL
Cqw12>= 99.9 %99.171539961014FAIL
Cqw12>= 99.9 %99.298493408663FAIL
Cqw12>= 99.9 %99.408602150538FAIL
Cqw12>= 99.9 %99.518779342723FAIL
Cqw12>= 99.9 %99.533333333333FAIL
Cqw12>= 99.9 %99.615384615385FAIL
Cqw12>= 99.9 %99.694802098236FAIL
Cqw12>= 99.9 %99.703878406709FAIL
Cqw12>= 99.9 %99.771622934888FAIL
Cqw12>= 99.9 %99.79093258163FAIL
Cqw12>= 99.9 %99.83164983165FAIL
Cqw12>= 99.9 %99.847222222222FAIL
Cqw12>= 99.9 %99.85641025641FAIL
Cqw12>= 99.9 %99.870801033592FAIL
Cqw12>= 99.9 %99.894296951819FAIL
Cqw12>= 99.9 %93.548387096774FAIL
Cqw12>= 99.9 %96.153846153846FAIL
Cqw12>= 99.9 %96.428571428571FAIL
Cqw12>= 99.9 %98.103038936372FAIL
Cqw12>= 99.9 %99.328908554572FAIL
Cqw12>= 99.9 %99.705743879473FAIL
Cqw12>= 99.9 %99.85754985755FAIL
Cqw12>= 99.9 %99.881944444444FAIL
FRQO >= 99.9 %99.96475327291PASS
FRQO >= 99.9 %99.987816764133PASS
FRQO >= 99.9 %99.990476190476PASS
FRQO >= 90 %93.548387096774PASS
Cqw12>= 99.9 %96.666666666667FAIL
Cqw12>= 99.9 %99.414348462665FAIL
FRQO >= 99.9 %99.945679012346PASS
FRQO >= 99.9 %99.9528524281PASS
FRQO >= 90 %96.774193548387PASS
Cqw12>= 99.9 %97.721734892788FAIL
Cqw12>= 99.9 %99.536252354049FAIL
Cqw12>= 99.9 %99.868421052632FAIL
FRQO >= 99.9 %99.917608286252PASS
FRQO >= 99.9 %99.91984912777PASS
FRQO >= 99.9 %99.961850262279PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
Cqw12>= 99.9 %99.892676767677FAIL
Cqw12>= 99.9 %99.206349206349FAIL
QEF >= 99.9 %99.984217171717PASS
QEF >= 99.9 %99.987373737374PASS
QEF >= 99.9 %99.987852283771PASS
QEF >= 99.9 %99.990503323837PASS
QEF >= 99.9 %99.95301855767PASS
QEF >= 99.9 %99.416484318016FAIL
QEF >= 99.9 %99.537558685446FAIL
QEF >= 99.9 %99.868804664723FAIL
QEF >= 99.9 %99.920131548039PASS
QEF >= 99.9 %99.945879458795PASS
QEF >= 99.9 %99.961986220005PASS
QEF >= 99.9 %97.728377065112FAIL
QEF >= 99.9 %99.917840375587PASS
QEF >= 99.9 %100PASS
QEF >= 90 %95.238095238095PASS
QEF >= 90 %95.454545454545PASS
QEF >= 97 %99.297052154195PASS
QEF >= 97 %99.496753246753PASS
FRQO >= 99.5 %99.620181405896PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 98 %100PASS
FRQO >= 97 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 98 %100PASS
FRQO >= 90 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 98 %100PASS
FRQO >= 90 %96.774193548387PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 98.5 %100PASS
FRQO >= 97 %99.680511182109PASS
FRQO >= 97 %99.846804014791PASS
FRQO >= 97 %100PASS
FRQO >= 90 %100PASS
FRQO >= 99.8 %100PASS
FRQO >= 97 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 97 %100PASS
FRQO >= 90 %95.833333333333PASS
FRQO >= 97 %99.604430379747PASS
FRQO >= 99.5 %99.604430379747PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 90 %86.206896551724FAIL
FRQO >= 90 %93.548387096774PASS
FRQO >= 90 %95.454545454545PASS
FRQO >= 90 %96.551724137931PASS
FRQO >= 97 %98.032407407407PASS
FRQO >= 97 %99.271442495127PASS
FRQO >= 97 %99.771090534979PASS
FRQO >= 97 %99.796650717703PASS
FRQO >= 97 %99.852430555556PASS
Cqw12>= 99.5 %99.271442495127FAIL
Cqw12>= 99.5 %99.649122807018PASS
Cqw12>= 99.5 %99.771090534979PASS
Cqw12>= 99.8 %98.349889624724FAIL
Cqw12>= 99.8 %99.743150684932FAIL
Cqw12>= 97 %98.954402515723PASS
Cqw12>= 99.5 %98.032407407407FAIL
Cqw12>= 99.5 %98.683127572016FAIL
Cqw12>= 99.5 %99.851364522417PASS
Cqw12>= 99.5 %99.852430555556PASS
Cqw12>= 99.8 %98.299086757991FAIL
Cqw12>= 99.8 %99.663355408389FAIL
Cqw12>= 99.5 %98.954402515723PASS
Cqw12>= 99.8 %99.670542635659FAIL
QEF >= 99.8 %99.869047619048PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.8 %100PASS
QEF >= 99.5 %100PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.8 %100PASS
QEF >= 99.5 %100PASS
QEF >= 97 %99.615384615385PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.8 %100PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.9 %100PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.8 %100PASS
QEF >= 99.5 %100PASS
Cqw12>= 90 %100PASS
Cqw12>= 97 %100PASS
Cqw12>= 99.9 %100PASS
QEF >= 90 %96.666666666667PASS
QEF >= 97 %99.886524822695PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
Cqw12>= 90 %0FAIL
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.5 %100PASS
QEF >= 90 %93.548387096774PASS
QEF >= 97 %97.939814814815PASS
QEF >= 97 %99.202508960573PASS
QEF >= 99.5 %87.304067460317FAIL
QEF >= 99.5 %96.582181259601PASS
Cqw12>= 99.5 %97.939814814815FAIL
QEF >= 99.5 %99.236111111111PASS
Cqw12>= 99.5 %99.357638888889FAIL
Cqw12>= 99.5 %99.386200716846FAIL
Cqw12>= 99.8 %88.195238095238FAIL
Cqw12>= 99.8 %98.472222222222FAIL
Cqw12>= 99.8 %98.89880952381FAIL
OUQ>= 99.8 %99.170918367347PASS
Cqw12>= 99.8 %99.367816091954FAIL
QEF >= 99.8 %99.744701348748PASS
QEF >= 99.8 %99.774659863946PASS
QEF >= 99.8 %99.782430213465PASS
Cqw12>= 99.5 %99.202508960573FAIL
Cqw12>= 99.8 %99.388888888889FAIL
PGMX>= 99.5 %99.881272401434PASS
PGMX>= 90 %100PASS
PGMX>= 97 %100PASS
PGMX>= 99.8 %100PASS
PGMX>= 99.5 %100PASS
PGMX>= 99.2 %100PASS
PGMX>= 90 %100PASS
PGMX>= 97 %100PASS
FRQO >= 90 %96.666666666667PASS
FRQO >= 90 %96.774193548387PASS
FRQO >= 97 %99.898018648019PASS
FRQO >= 97 %99.901795735129PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 90 %96.296296296296PASS
FRQO >= 97 %99.743209876543PASS
FRQO >= 98 %99.743209876543PASS
FRQO >= 90 %100PASS
FRQO >= 98 %100PASS
FRQO >= 97 %100PASS
QEF >= 90 %100PASS
QEF >= 97 %100PASS
QEF >= 99.8 %100PASS
QEF >= 99.5 %100PASS
FRQO >= 97 %100PASS
FRQO >= 98.5 %100PASS
FRQO >= 90 %96.774193548387PASS
FRQO >= 97 %99.810606060606PASS
FRQO >= 97 %99.930555555556PASS
Cqw12>= 99.6 %96.111111111111FAIL
Cqw12>= 99.6 %97.916666666667FAIL
Cqw12>= 99.6 %98.387096774194FAIL
FRQO >= 99.6 %99.810606060606PASS
FRQO >= 99.6 %99.930555555556PASS
Cqw12>= 99.7 %94.166666666667FAIL
Cqw12>= 99.7 %95.333333333333FAIL
Cqw12>= 99.7 %97.5FAIL
FRQO >= 99.7 %99.916666666667PASS
FRQO >= 99.8 %100PASS
FRQO >= 97 %97.916666666667PASS
FRQO >= 97 %98.387096774194PASS
FRQO >= 97 %99.772727272727PASS
FRQO >= 97 %99.895833333333PASS
Cqw12>= 99.6 %97.5FAIL
FRQO >= 99.6 %99.772727272727PASS
FRQO >= 99.6 %99.916666666667PASS
Cqw12>= 99.7 %82.708333333333FAIL
FRQO >= 99.7 %99.895833333333PASS
FRQO >= 90 %95PASS
FRQO >= 90 %95.454545454545PASS
Cqw12>= 97 %96.875FAIL
FRQO >= 97 %99.916666666667PASS
FRQO >= 99.6 %0PASS
Cqw12>= 99.6 %95.333333333333FAIL
Cqw12>= 99.7 %96.875FAIL
FRQO >= 97 %97.5PASS
FRQO >= 97 %0PASS
FRQO >= 90 %100PASS
FRQO >= 99.7 %100PASS
FRQO >= 99.6 %100PASS
FRQO >= 97 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 98 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 90 %96.551724137931PASS
Cqw12>= 97 %96.874714220393FAIL
FRQO >= 97 %97.973588342441PASS
FRQO >= 97 %99.300779458964PASS
FRQO >= 97 %99.912280701754PASS
FRQO >= 97 %100PASS
FRQO >= 90 %100PASS
FRQO >= 98.5 %100PASS
FRQO >= 90 %92.307692307692PASS
FRQO >= 90 %95.652173913043PASS
FRQO >= 97 %97.516483516484PASS
FRQO >= 97 %97.608465608466PASS
FRQO >= 97 %99.809523809524PASS
FRQO >= 97 %99.824761904762PASS
FRQO >= 98 %99.809523809524PASS
FRQO >= 98 %99.81746031746PASS
FRQO >= 98 %99.831501831502PASS
FRQO >= 98.5 %99.81746031746PASS
FRQO >= 98 %97.608465608466PASS
FRQO >= 98 %99.824761904762PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 98 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.8 %100PASS
FRQO >= 90 %100PASS
FRQO >= 99.8 %100PASS
FRQO >= 97 %100PASS
FRQO >= 99.5 %100PASS
FRQO >= 90 %100PASS
FRQO >= 97 %100PASS
FRQO >= 95 %100PASS
FRQO >= 70 %76.666666666667PASS
->= 70 %79.310344827586PASS
Cqw12>= 90 %61.538461538462FAIL
Cqw12>= 90 %86.666666666667FAIL
->= 90 %90PASS
->= 90 %91.666666666667PASS
->= 90 %95.454545454545PASS
->= 90 %95.652173913043PASS
->= 95 %99.917440660475PASS
->= 95 %99.919799498747PASS
Cqw12>= 97 %65.160256410256FAIL
Cqw12>= 97 %90.454611054986FAIL
Cqw12>= 97 %92.025089605735FAIL
Cqw12>= 97 %93.655172413793FAIL
Cqw12>= 97 %94.372693726937FAIL
Cqw12>= 97 %96.666666666667FAIL
->= 97 %97.016129032258PASS
->= 97 %97.083333333333PASS
->= 97 %97.526666666667PASS
->= 97 %97.728494623656PASS
->= 97 %97.887045813586PASS
->= 97 %98.482632541133PASS
->= 97 %98.577777777778PASS
->= 97 %98.70987654321PASS
->= 97 %98.768518518519PASS
->= 97 %98.776301218162PASS
->= 97 %98.810256410256PASS
->= 97 %98.8125PASS
->= 97 %98.830769230769PASS
->= 97 %98.943833943834PASS
->= 97 %99.010047281324PASS
->= 97 %99.031954887218PASS
->= 97 %99.190385831752PASS
->= 97 %99.254032258065PASS
->= 97 %99.266666666667PASS
Cqw12>= 97 %99.345340194397FAIL
->= 97 %99.388221841052PASS
->= 97 %99.468599033816PASS
->= 97 %99.627586206897PASS
->= 97 %99.634615384615PASS
->= 97 %99.647355163728PASS
->= 97 %99.65873015873PASS
->= 97 %99.668381932533PASS
->= 97 %99.732510288066PASS
->= 97 %99.733333333333PASS
->= 97 %99.742424242424PASS
->= 97 %99.749373433584PASS
->= 97 %99.758020663404PASS
->= 97 %99.7668997669PASS
->= 97 %99.777777777778PASS
->= 97 %99.790476190476PASS
->= 97 %99.800637958533PASS
->= 97 %99.818666666667PASS
->= 97 %99.826576576577PASS
Cqw12>= 97 %99.831111111111FAIL
->= 97 %99.831989247312PASS
->= 97 %99.854586129754PASS
->= 97 %99.868055555556PASS
->= 97 %99.894475481068PASS
->= 97 %99.899193548387PASS
->= 97 %99.912280701754PASS
->= 97 %99.923195084485PASS
->= 97 %99.942528735632PASS
->= 97 %99.968193384224PASS
->= 97 %99.979674796748PASS
->= 97 %99.988026819923PASS
Cqw12>= 98 %93.655172413793FAIL
->= 98 %98.70987654321PASS
->= 98 %98.830769230769PASS
->= 98 %98.943833943834PASS
->= 98 %99.113260781943PASS
->= 98 %99.344262295082PASS
->= 98 %99.517304189435PASS
->= 98 %99.659329140461PASS
->= 98 %99.680255795364PASS
->= 98 %99.717948717949PASS
->= 98 %99.742424242424PASS
Cqw12>= 98.5 %98.474358974359FAIL
->= 98.5 %99.166666666667PASS
->= 99 %99.254032258065PASS
->= 99 %99.599537037037PASS
->= 99 %99.831989247312PASS
->= 99 %99.854586129754PASS
->= 99.2 %100PASS
Cqw12>= 99.5 %97.37684729064FAIL
Cqw12>= 99.5 %97.728494623656FAIL
Cqw12>= 99.5 %97.73425499232FAIL
Cqw12>= 99.5 %99.146825396825FAIL
->= 99.5 %99.599537037037PASS
->= 99.5 %99.630541871921PASS
->= 99.5 %99.790476190476PASS
->= 99.5 %99.831989247312PASS
->= 99.5 %99.912280701754PASS
->= 99.5 %99.912698412698PASS
->= 99.5 %99.97311827957PASS
Cqw12>= 99.9 %90FAIL
Cqw12>= 99.9 %96.666666666667FAIL
Cqw12>= 99.9 %98.577777777778FAIL
Cqw12>= 99.9 %99.010047281324FAIL
Cqw12>= 99.9 %99.388221841052FAIL
Cqw12>= 99.9 %99.668381932533FAIL
Cqw12>= 70 %0FAIL
->= 70 %100PASS
->= 90 %92.307692307692PASS
->= 90 %96.428571428571PASS
->= 95.5 %100PASS
->= 97 %98.946360153257PASS
->= 97 %98.982951205173PASS
->= 97 %99.333333333333PASS
->= 97 %99.667832167832PASS
->= 98 %98.776301218162PASS
->= 98 %98.810256410256PASS
->= 98 %99.20936116382PASS
->= 98 %99.647355163728PASS
->= 98 %99.749373433584PASS
->= 98 %99.802371541502PASS
->= 98 %99.894475481068PASS
->= 98.4 %99.923076923077PASS
->= 98.4 %100PASS
Cqw12>= 99.5 %98.982951205173FAIL
Cqw12>= 99.5 %99.254032258065FAIL
->= 99.5 %99.517304189435PASS
->= 99.5 %99.854586129754PASS
Cqw12>= 99.7 %65.160256410256FAIL
->= 99.7 %100PASS
Cqw12>= 99.9 %96.774193548387FAIL
->= 90 %90.322580645161PASS
->= 90 %96.296296296296PASS
->= 97 %98.474358974359PASS
->= 97 %99.517304189435PASS
->= 97 %99.74358974359PASS
Cqw12>= 99 %98.946360153257FAIL
->= 90 %93.333333333333PASS
->= 95 %98.666666666667PASS
->= 95 %98.774509803922PASS
->= 90 %96.666666666667PASS
->= 90 %96PASS
->= 90 %96.153846153846PASS
Cqw12>= 99.9 %99.586288416076FAIL
->= 90 %96.774193548387PASS
->= 0 %100PASS
-> 99.5 %100PASS
-> 99.8 %100PASS
->= 99.8 %100PASS
->= 95 %100PASS
->= 98.5 %100PASS
->= 99 %100PASS
->= 99.5 %100PASS
->= 99.9 %100PASS
->= 90 %100

PASS

6 Replies
sunny_talwar

Would you be able to share an application where you might have already loaded the data and are working on the chart? I guess your requirement is urgent, it might help us if we can start working on a somewhat working app, rather than create one from scratch, right?

mshailaja
Contributor III
Contributor III
Author

actuaally i cannot upload qvw file,thats why i have given you screen shots

please help me

susovan
Partner - Specialist
Partner - Specialist

You can try this way,

40.JPG

Warm Regards,
Susovan
mshailaja
Contributor III
Contributor III
Author

if i put like this

it is coming like this for Avg(meaurement) no blue is displaying

susovan
Partner - Specialist
Partner - Specialist

so,

You can set the number format for this same expression from number tab.

Warm Regards,
Susovan
mshailaja
Contributor III
Contributor III
Author

No luck