topic Ranking disregarding the Dimension in QlikView

Ranking disregarding the Dimension

Tue, 07 Oct 2014 17:40:46 GMT

Hi All,

Have created a block chart with colouring logic as below.

Rank Clinical Area on basis of Internal Cost Variance and colour the blocks as

Top 1/3^rd Clinical Area(with highest internal cost variance) are coloured red, in our case CA6,CA5 and CA3
Middle i.e. 1/3^rd to 2/3^rd yellow
Bottom 1/3^rd Red

So right now we are dividing all clinical area in 3 groups

I find out max rank here it is 9, 1/3rd of rank i.e. 3 and 2/3rd i.e. 6, than in block chart written logic in background colour to give respective colours

Clinical Area	Internal Cost Variance	Rank
CA1	210	7
CA2	675	4
CA3	7896	3
CA4	31	8
CA5	78971	2
CA6	1000000	1
CA7	345	5
CA8	321	6
CA9	12	9

Issue is user wants to select on Block chart, so when they select a particular clinical Area, ranking goes away and so does Colouring, i have also attached the app , your help would be much appreciated.

So the point is to keep max rank same irrespective of Clinical Area Selection.

Regards,

Anwar

Re: Ranking disregarding the Dimension

phaneendra_kunc — Tue, 07 Oct 2014 18:36:35 GMT

Quick Question...

What does State1 and State2 does in your app? i see you are passing selections of clinical_Area from state2 to state1.

Re: Ranking disregarding the Dimension

Wed, 08 Oct 2014 05:29:47 GMT

I have created Alternate State, in the original app we have filter which only apply to Block chart.

Re: Ranking disregarding the Dimension

tresB — Wed, 08 Oct 2014 06:11:22 GMT

Try with ALL keyword, like:

=Max(ALL Aggr(rank(sum({<DATE_DT={">=$(vPeriodStart)<=$(vPeriodEnd)"},MEASURE_NAME=,MEASURE_GROUP_ID=,Clinical_Area=,FUNCTIONAL_AREA_NAME=,Quality_Measure=>} MEASURE_NUMERATOR)),Clinical_Area))

Re: Ranking disregarding the Dimension

Wed, 08 Oct 2014 07:24:18 GMT

Thanks Tresesco it worked.