topic Re: Aggregation in Variable in QlikView

Aggregation in Variable

Fri, 12 Sep 2014 04:34:13 GMT

Hi folks,

i am stuck with below issue and have tried lot of different stuff but cant solve it.

I am Plotting a Bar graph with below details

Dimensions

1) Facility and 2) Days_To_Readmit

Measure

1) count(encounters) per days_to_Readmit / Count(encounter) group by Facility for all Days_to_readmit

I created variable which will store denominator part and give me total encounter, issue is variable is giving me total combining all the facility present, where as i want it by each facility.

e.g. if total encounters for Facility 1 is 20 and Facility 2 is 100 than bar should be plotted for each facility as Numerator of Facility1/20 and Numerator of Facility2/100 right now it is coming as Numerator of Facility1/120 and Numerator of Facility2/120

i have attached the app as well, your help would be much appreciated.

Thanks

Re: Aggregation in Variable

tresB — Fri, 12 Sep 2014 05:13:04 GMT

Corrected the variable definition. PFA

Re: Aggregation in Variable

Fri, 12 Sep 2014 05:47:32 GMT

Hey Tresesco,

Thanks for reply, i am not able to open your document.

Please let me know what changes you have done.

Regards

Re: Aggregation in Variable

tresB — Fri, 12 Sep 2014 05:55:07 GMT

Variable definition:

Aggr(NODISTINCT count({<DISCHARGE_DATE_DT={">=$(vMinDate)<=$(vMaxDate)"},INDEX_READMIT_FLAG={I}, DAYS_TO_READMIT=>}ENCOUNTER_QO_KEY),Facility_Name)

Note: no '=' in front.

And '$' sign before variable name in the expression like: .......TER_QO_KEY)/$(Encounter_Count)

Re: Aggregation in Variable

Fri, 12 Sep 2014 06:19:50 GMT

Thanks tresesco really appreciate your help.