Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Query

 

 

Consolidated KPI

 

CountryProductyearmonthDateweekweek_noAPPLICATIONSSTPAPPROVEDCANCELLEDDECLINEDSTP_RATEAPPROVAL_RATECANCLE_RATEDECLINE_RATECYCLE_TIMEapps_samedayapps_1to3_daysapps_3to5_daysapps_5to10_daysapps_gt10_daysCYCLE_TIME_STPCYCLE_TIME_REFLT3daysAppPer
MYHC201820180901SEP2018  239401144686733304119630.4781119470.4202849390.1380116960.57971506110.12694569117129514573250255412.398537489.9740339650.162804105
MYHC201820181001OCT2018  2940414666101084316149780.4987756770.4029339070.1467827510.5970660938.713692125687233324262238242416.443267788.1728591090.298773249
MYHC201820181101NOV2018  262461260993993753130940.4804160630.4178633350.1429932180.5821366657.298329611260294818531384195417.799003326.5797430940.447707203
MYHC201820181201DEC2018  2626011742101623332127660.4471439450.4432135380.1268849960.5567864625.7684510922627298218031308144215.894833955.1979209980.551958276
MYHC201920190101JAN2019  3041315295106353677161010.502909940.3977782760.1209022460.6022217244.5367183834476251111131292124310.925764194.2491893490.656981664
MYHC201920190201FEB2019  215391024880043064104700.4757881050.4332575510.1422535870.5667424495.595952024298018527821077131313.971496445.1309508110.603698151
MYHC201920190301MAR2019  2752613749100343649138370.499491390.4203426750.1325655740.5796573255.0770380713639222812901542133511.23204424.7248972710.584711979
MYHC201920190401APR2019  2920114174105114011146780.4853943360.4172853230.137358310.5827146775.3535343934217206410531509166813.14828214.9206668010.597564456
MYHC201920190501MAY2019  3012315569107873133162030.5168475920.3996665430.1040069050.6003334575.273106517376028121102146416499.7524154594.9006928410.609251877
MYHC201920190601JUN2019  248351266690063331124980.510006040.4188058040.1341252260.5811941967.1753275591282245917761581190814.16771166.6422084130.41538974
MYHC201920190701JUL2019  3116115593109684494156990.5004011420.4112948590.1442187350.5887051415.893143691360319611488193719798.4838255985.713561470.507293946
MYHC201920190801AUG2019  3054915324108773685159870.5016203480.4048913040.120625880.5951086965.2447366388721431186198916726.6851851855.1534851890.554380804
MYHC201920190901SEP2019  253561269593253106129230.5006704530.4191387990.1224956620.5808612014.903699732370716001251138013876.1184433164.8215021750.569115282
MYHC201920191001OCT2019  2887714685102923610149740.5085362050.407345840.1250129860.592654164.494170229443316511143185512105.0755336624.4576061140.591138749
MYHC201920191101NOV2019  3107914773124093788148790.4753370440.4547420110.1218829430.5452579894.812233057496024521532161618495.8330757344.7560788980.597308405
MYHC201920191201DEC2019  3252815691126494996148800.4823844070.4594790950.1535907530.5405209054.71309985368733712048214913947.3129370634.5899643950.557988774
MYHC202020200101JAN2020  3208116343119324246159030.5094292570.4286689420.1323524830.5713310583.413426081658121101031119010205.6512651273.2288850590.728377472
MYHC202020200201FEB2020  265531317796924762120990.4962527770.4447707770.1793394340.5552292234.143314073493315939121047120710.252288913.4537834420.673338836
MYHC202020200301MAR2020  237051137490173982107050.4798143850.4572051520.1679814390.5427948483.7777531334557149591311309227.1841680133.5266730170.671176666
MYHC202020200401APR2020  11587273031097460.6278065630.288846520.0941278070.711153488.92739273911723103012310.263157898.8380281690.462046205
MYHC201820180801AUG201827AUG2018341911233683720.6439790580.3333333330.4345549740.6666666679.4166666670314127238.6176470590.083333333
MYHC201820180901SEP201803SEP20183566973333237374235820.4976855310.3984886650.1107958790.6015113359.8659924153030420111646749.2440476199.9133786850.140750105
MYHC201820180901SEP201810SEP20183650222271196268723730.4522102750.4525951560.1367980880.5474048449.99592252834159221103251613.342105269.7895021650.098369011
MYHC201820180901SEP201817SEP20183759082962203680330690.5013540960.3988246820.13591740.6011753189.7082514734249640243566113.040650419.49398850.264243615
MYHC201820180901SEP201824SEP20183861222757226698928670.4503430250.4414572370.1615485140.55854276310.90114741133361960769614.710.650987770.151809356
MYHC201820181001OCT201801OCT201839631431902094119230280.5052264810.4088246780.1887868230.59117532211.486628463731545258870216.5699481910.970541820.168099331
MYHC201820181001OCT201808OCT201840666332892329107132610.4936214920.4166368520.1607384060.5833631489.6470588247344648169063912.559.4613978990.222842422
MYHC201820181001OCT201815OCT20184163582934236588531080.461465870.4321213230.1391947150.5678786778.0524312918562655048751717.611111117.4326879780.342917548
MYHC201820181001OCT201822OCT20184261753169201076733980.5131983810.3716715980.1242105260.6283284026.38059701530769242126232817.617021285.8293319420.497014925
MYHC201820181001OCT201829OCT20184366123454228784634790.5223835450.3966354490.1279491830.6033645517.3113248813277659237441320.810975616.2684879890.397026672
MYHC201820181101NOV201805NOV20184454462750190061629300.5049577670.3933747410.113110540.6066252597.85684210515641255439438417.472602747.0564424170.298947368
MYHC201820181101NOV201812NOV20184568153283243090334820.4817314750.4110284170.1325018340.5889715836.97777777821984954833647813.181818186.5898557060.439506173
MYHC201820181101NOV201819NOV201846512822901840104422440.4465678630.4505386880.2035881440.5494613127.862525551739727140021.540740746.7794721410.419565217
MYHC201820181101NOV201826NOV20184763753063232077532800.4804705880.4142857140.1215686270.5857142867.00043103458367429422654318.570247936.3638017280.541810345
MYHC201820181201DEC201803DEC20184871253554249970739190.4988070180.3893736370.099228070.6106263635.92877150969172245827435415.036809825.2932363010.56542617
MYHC201820181201DEC201810DEC20184968553220260078134740.4697301240.4280540010.1139314370.5719459995.36923076958198646927728713.529411764.8590110340.602692308
MYHC201820181201DEC201817DEC201850677627202864109628160.4014167650.5042253520.1617473440.4957746485.9860335262767162651842217.116504855.5708076780.453212291
MYHC201820181201DEC201824DEC20185143951834172858120860.4172923780.4530676460.1321956770.5469323545.20601851968940515420827216.373333334.6993345430.633101852
MYHC201820181201DEC201831DEC20185246812325153958825540.4966887420.3760078180.1256141850.6239921824.8538011768834612813823913.388888894.4349011590.671864847
MYHC201920190101JAN201907JAN2019172153787245683639230.5248787250.3850133250.1158697160.6149866754.49226384410006383272362558.5413533834.2604390870.666938111
MYHC201920190101JAN201914JAN2019275903740276994038810.4927536230.4163909770.1238471670.5836090234.53304442103978828638627012.302325584.1534090910.659804984
MYHC201920190101JAN201921JAN2019359012728221877729060.4622945260.4328649490.1316725980.5671350514.82461677289443926832529216.964.3999066730.600991885
MYHC201920190101JAN201928JAN2019468563195265176734380.4660151690.4353752670.1118728120.5646247334.442474538106874823128631810.602040824.2060321190.685024519
MYHC201920190201FEB201904FEB2019536361790125863617420.492299230.4193333330.1749174920.5806666676.83068362532527615427822521.909090915.9958053690.477742448
MYHC201920190201FEB201911FEB2019657392748207587327910.4788290640.4264282780.1521170940.5735717225.8477108437624752171614608.1142857145.683720930.596144578
MYHC201920190201FEB201918FEB2019763512920241984930820.4597701150.4397382290.1336797350.5602617715.215378255109447419632932616.097560984.6324041810.648201736
MYHC201920190201FEB201925FEB2019861743173219471032700.5139293810.4015373350.114998380.5984626655.0305378388750020529830413.822916674.628217350.632178669
MYHC201920190301MAR201904MAR2019966663291244678134360.493699370.4158449510.1171617160.5841550495.08503679589953131838431411.365517244.6892655370.584627964
MYHC201920190301MAR201911MAR20191065363194241787932390.4886780910.4273338050.1344859240.5726661955.01944559489849932538031511.427631584.5894039740.577989243
MYHC201920190301MAR201918MAR20191164543390223590933080.5252556550.4032112570.1408428880.5967887435.0165548180849327834031610.548076924.7465978410.582102908
MYHC201920190301MAR201925MAR20191265523278239998231710.500305250.430700180.14987790.569299825.4026677787725563383953389.65.1816586220.553563985
MYHC201920190401APR201901APR201913674333042304101434250.4899896190.4021644270.150378170.5978355735.0273437589946528332133610.752136754.7210791040.592013889
MYHC201920190401APR201908APR20191469423261264288134180.4697493520.4359735970.1269086720.5640264035.375851628101759022338043210.477611945.1032695370.608251325
MYHC201920190401APR201915APR20191564573190229679933620.4940374790.4057971010.1237416760.5942028995.36106271894046417537434315.862903234.7615101290.611498258
MYHC201920190401APR201922APR20191664233034242581631820.4723649390.4324950950.1270434380.5675049055.373608247106240723934337416.231481484.8675010790.605773196
MYHC201920190401APR201929APR20191751032664173779525710.5220458550.4032033430.1557907110.5967966576.05584340857343116823333212.130952385.4053537280.57800806
MYHC201920190501MAY201906MAY20191871283626266272737390.5086980920.415872520.1019921440.584127484.86814425210017522392763947.7107142864.5340050380.658527423
MYHC201920190501MAY201913MAY20191974824036260368041990.539427960.3826815640.090884790.6173184365.01152516310275562823903489.3435897444.6607142860.608144449
MYHC201920190501MAY201920MAY20192052742674191562227370.5070155480.4116509030.117937050.5883490976.02872062743155924037031514.897196265.5038716810.516971279
MYHC201920190501MAY201927MAY20192178474028273381443000.5133171910.3885966160.1037339110.6114033845.427003293102765230628646213.323353294.913094310.614343213
MYHC201920190601JUN201903JUN20192238931840148652218850.4726432060.4408187480.1340868230.5591812527.00740242320937439226824314.967479676.2890682320.392328398
MYHC201920190601JUN201910JUN20192370753681248483637550.5202826860.3981407280.1181625440.6018592726.40539452552980921641052012.559701496.0544680850.538647343
MYHC201920190601JUN201917JUN201924710737372486101636050.5258196140.4081431620.1429576470.5918568387.12872083724783154737149012.831730776.6079894640.433628319
MYHC201920190601JUN201924JUN20192566853334253195332010.4987284970.4415561760.1425579660.5584438247.78387988929744562153263612.805194817.4585612120.293164757
MYHC201920190701JUL201901JUL20192670823483269798933960.4918102230.4426390940.1396498160.5573609066.1208750468374993994145487.8457711445.9819711540.495365221
MYHC201920190701JUL201908JUL20192770233623246095236110.5158764060.4052050730.1355546060.5947949276.34593495985540827044248510.91379315.9982502190.513414634
MYHC201920190701JUL201915JUL201928705935812279125135290.5072956510.3923898070.1772205690.6076101935.8767003078623332004424426.6557377055.8326379230.524352786
MYHC201920190701JUL201922JUL20192966903433224788635570.5131539610.3871467950.1324364720.6128532055.3386737876965173403972977.75.1697663330.539830886
MYHC201920190701JUL201929JUL20193059253059200272332000.516286920.384851980.1220253160.615148024.9110889117862843013592728.6315789474.6864406780.534465534
MYHC201920190801AUG201905AUG20193173953798257474440770.5135902640.3870094720.1006085190.6129905285.0990675997956543464023775.1265060245.097176080.562937063
MYHC201920190801AUG201912AUG20193261933049222569932690.492330050.4049872590.1128693690.5950127415.7047191015675272295773256.1544715455.6784015220.491685393
MYHC201920190801AUG201919AUG20193376133739275598438740.4911335870.4155981290.1292525940.5844018715.40943738710555043163934879.1678321685.2036753450.565880218
MYHC201920190801AUG201926AUG20193467433159260696031770.4684858370.450631160.1423698650.549368845.22716807410373782735004186.132530125.165573770.542977744
MYHC201920190901SEP201902SEP20193551402657183870126010.516926070.414057220.1363813230.585942784.4684439618912002033032415.9136690654.3502060040.593579978
MYHC201920190901SEP201909SEP20193652962716184761128360.5128398790.3944052960.1153700910.6055947045.0362750418402291982603206.1958041964.9389671360.578776394
MYHC201920190901SEP201916SEP20193762853161235771032180.5029435160.4227802690.1129673830.5772197314.8362324998804203953433196.3985507254.7390716540.551548579
MYHC201920190901SEP201923SEP20193873513558276082937620.484015780.4231830730.1127737720.5768169274.96666666710155813633834185.5820895524.9352627570.57826087
MYHC201920190901SEP201930SEP20193969263457256793134270.4991336990.4282615950.1344210220.5717384054.27347097810905532364192695.21254.2110511010.640046747
MYHC201920191001OCT201907OCT20194065243255240083832860.4989270390.4220893420.1284488040.5779106584.60291666710183832734392874.9319727894.581446960.58375
MYHC201920191001OCT201914OCT20194169983591245583837050.5131466130.3985389610.11974850.6014610394.44236252510184622884022855.4792899414.3657042870.602851324
MYHC201920191001OCT201921OCT20194261823075222490930490.4974118410.4217712880.1470397930.5782287124.5395683459073722694052714.9803921574.5183788880.575089928
MYHC201920191001OCT201928OCT20194350082661171147728200.531349840.3776208340.0952476040.6223791665.0701344247551521713892444.98755.0741876150.530099357
MYHC201920191101NOV201904NOV201944728032912995101832670.452060440.4782816990.1398351650.5217183015.217696169956894513005605.9822485215.1719745220.562270451
MYHC201920191101NOV201911NOV20194573763472299688934910.4707158350.461846770.120526030.538153234.55574098812825773883174325.2383720934.5141643060.620493992
MYHC201920191101NOV201918NOV20194671973525287288234410.4897874110.4549342630.1225510630.5450657375.08565459610995183534604426.9707602344.9663087750.563022284
MYHC201920191101NOV201925NOV20194777723750301187138890.4825012870.4363768120.1120689660.5636231884.50083028913125713384313595.5806451614.4544509870.62537363
MYHC201920191201DEC201902DEC201948749239042618118436900.5210891620.4150285350.1580352380.5849714654.8617265097108083774302937.981254.6586655820.579831933
MYHC201920191201DEC201909DEC201949892545113351131842540.5054341740.4406311640.147675070.5593688364.8364667268758776096323586.1241830074.7748592870.522829006
MYHC201920191201DEC201916DEC201950781337173153113335270.4757455520.4720059880.1450147190.5279940124.4341896619588385065333185.8461538464.3671096350.569616239
MYHC201920191201DEC201923DEC201951591026722418102924620.4521150590.4954918030.1741116750.5045081974.8064516137196043944072948.5955056184.6616573640.547146402
MYHC201920191201DEC201930DEC20195249422240200773022050.453257790.4764957260.1477134760.5235042744.5884404588744251922482688.0821917814.4565667010.647234679
MYHC202020200101JAN202006JAN2020171913743268793435700.5205117510.4294390280.1298845780.5705609723.2943803516784091611802595.5909090913.1116914420.776702642
MYHC202020200101JAN202013JAN2020275803943278277540230.5201846970.4088170460.1022427440.5911829543.17469446416384192252802204.3333333333.1058644330.739396118
MYHC202020200101JAN202020JAN20203809941192938118139800.5085813060.4246892170.1458204720.5753107833.31960517416635341962982476.7073170733.1193222780.747787611
MYHC202020200101JAN202027JAN2020466873223262696031010.4819799610.4585297710.1435621350.5414702293.54303122611515634213311606.1088825213.1497584540.652703732
MYHC202020200201FEB202003FEB20205622029862404110527110.4800643090.4699902250.1776527330.5300097754.74251247910384842492373967.7170418014.3005255610.633111481
MYHC202020200201FEB202010FEB20206659331202351122630160.4732291820.4380473260.1859548010.5619526743.970650787129433019426526810.439655173.2623879190.690769885
MYHC202020200201FEB202017FEB20207681936002446114832250.5279366480.4313172280.1683531310.5686827724.595257563120037724829133013.981818183.4062643940.644726083
MYHC202020200201FEB202024FEB20208689034412485127831270.4994194480.442801140.1854862120.557198863.21287726414014022192542097.906252.8898924730.72555332
MYHC202020200301MAR202002MAR2020966893226257592331910.4822843470.446583420.1379877410.553416583.29436893214513532513112096.4368932043.0211059520.700582524
MYHC202020200301MAR202009MAR20201068533205274594131660.4676783890.4643884280.1373121260.5356115723.25901639314754882383282165.1803278693.1217798590.715118397
MYHC202020200301MAR202016MAR20201156712657219581026660.468524070.4515531780.1428319520.5484468224.00956719810163872732952246.6412213743.842538760.639179954
MYHC202020200301MAR202023MAR202012384019381281120413550.50468750.4859635810.3135416670.5140364194.9352068753423813317420213.423913044.2783851980.602654176
MYHC202020200301MAR202030MAR20201312086663941526620.5513245030.3731060610.1258278150.6268939397.4771573614842244113910.557.3128342250.482233503
MYHC202020200401APR202006APR202014567378130553820.6666666670.253906250.0970017640.746093759.7769230775010411558.6666666679.830645161

0.461538462

 

 

 

Labels (1)