topic Re: Input Box for Top X Percentile in QlikView

Input Box for Top X Percentile

phcaptjim — Wed, 19 Feb 2014 12:22:41 GMT

All,

I'm struggling to create an Input Box so the user can filter the data for a certain percentile. I'm building a healthcare application and I want the user to be able to enter the percentage they wish to filter patients on. For example, lets say the user selects 2013 as the year, then they want to see the patients in the top 1% of charges. This seems quite challenging since this calculation has to be done outside of a chart/table.

For patients that meet the criteria, I will have a trigger select patient ID's for those that fall into the percentile entered by the user. I've searched the forums but was unable to find anything that calculates percentiles outside of an object. Any ideas?

Thanks!

Relevant fields in my app:

Patient_ID

Patient_Name

Charge_Amount

Re: Input Box for Top X Percentile

sivarajs — Wed, 19 Feb 2014 13:19:51 GMT

If your working with QV11 then it is easy. Check the attached file. You can use the variable in dimension limit and input box to user to enter the number.

Else you need include variable in expression.

Re: Input Box for Top X Percentile

phcaptjim — Wed, 19 Feb 2014 13:34:13 GMT

That works well for displaying the results in a chart, but I need the patients to be SELECTED so all of my charts/tables reflect just that population of patients. I have similar input boxes for ed visits, admissions, etc. and each of those use a trigger to select Patient ID's when the condition is met.

For example, here is how I am selecting ED patients:

='(' & Concat({<[Patient ID]>}if(aggr(sum({<[Patient ID]>}ED_Seen_Flag),[Patient ID])>= v_EDVisits, [Patient ID]), '|') & ')'

v_EDVisits is the variable where the user enters into the input box.

I want to do the same type of trigger for Top X Percentile.