Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mshailaja
Contributor III
Contributor III

NEED HELP

Hi i have table with 3 dimensions  , i need to represent them in charts format(Not in  staright table, Pivot table) to reperesnt the meaning full data ,  the 3 dimensions are KPIName, Threshold, Mesurement , Can anyone  please help

Below i s sample data

i dnt want count, max functions in  expressions,  for each kpi, i need to show the measurements and threshold in bars or line

7 Replies
Anonymous
Not applicable

Hi sailaja,

If you have few KPI you can use Trellis option, see this help: https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Trellis_Settings.htm It is for 12 version, but is usefull for lower versions.

If you have a lot of them, I think that better way is a line chart, something like this:

Regards!!

varshavig12
Specialist
Specialist

It's not very clear.

What exactly you want ?

Also, from the excel sheet, how is this threshold value calculated,

for example:

-----> The value of measurement for KPI  AD is between 96 and 97 , still one of them has 97% as a threshold and other one as 99.9 %.

  

AD96.823406478579>= 99.9 %
AD96.858740578653>= 97 %

What is the logic behind this ?

mshailaja
Contributor III
Contributor III
Author

hi , I have charts  like below,

ineed to present them in % , how can i show

, Can anyone please look

Anonymous
Not applicable

Hi sailaja,

You have to change number format, and divide by 100 your expression:

Regards!

mshailaja
Contributor III
Contributor III
Author

Actually there are  4 columns coming form the database ( measures Threshold, Outcome Name)

If Out come is pass(Measurement is greater tha threhold)

If out come is fail(Measurement is less than threshold)

Now i want to showin the graphs  Avg of Measures and Thresholds  based on Name

here is the sample data, can anyone please help

   

NameTHRESHOLDMEASUREMENTOUTCOME
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
Anonymous
Not applicable

See attachment

Regards!

mshailaja
Contributor III
Contributor III
Author

hi

I want to show in axes from 92 to 100

how