https://community.qlik.com/t5/QlikView/Set-Analysis-Assistance/m-p/201921#M59813 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P>I was wondering if anyone could be of assistance. I would like to rank data using set analysis.</P><P>Load * Inline [</P><P>Doctor, DIagnosis, Treatement Intent, Cost</P><P>John Test, Breast Cancer, Curative, 20000</P><P>John Test, Colon Cancer, Curative, 25000</P><P>John Test, Breast Cancer, Curative, 25000</P><P>Ben One, Prostate Cancer, Palliative - Symptom Control, 15500</P><P>Stuart Hen, Prostate Cancer, Palliative - Improved Survival, 10000</P><P>Stuart Hen, Prostate Cancer, Curative, 18000</P><P>Ben One, Brain Cancer, Curative, 85000</P><P>Stuart Hen, Bone Cancer, Palliative - Improved Survival, 16900</P><P>];</P><P></P><P>Above is a simplistic example of the type of data that I am working worth. What I would like to do is to rank according to Diagnosis, then rank according to Treatment Intent in another table based on the Doctor selected.</P><P></P><P>I would need to fields of output, one which has the data ranked within the table, i.e. prostate cancer, bone cancer etc for that specific doctor and then the second field to rank the diagnosis overall, i.e. for that specific doctor the cost for prostate cancer was ranked against all doctors cost for prostate cancer.</P><P></P><P>Your assistance would be greatly appreciated.</P><P></P><P>Kind regards,</P><P>Bhavesh</P></BODY></HTML> Wed, 15 Sep 2010 13:29:57 GMT 2010-09-15T13:29:57Z https://community.qlik.com/t5/QlikView/Set-Analysis-Assistance/m-p/201921#M59813 <HTML><HEAD></HEAD><BODY><P>Good Day,</P><P>I was wondering if anyone could be of assistance. I would like to rank data using set analysis.</P><P>Load * Inline [</P><P>Doctor, DIagnosis, Treatement Intent, Cost</P><P>John Test, Breast Cancer, Curative, 20000</P><P>John Test, Colon Cancer, Curative, 25000</P><P>John Test, Breast Cancer, Curative, 25000</P><P>Ben One, Prostate Cancer, Palliative - Symptom Control, 15500</P><P>Stuart Hen, Prostate Cancer, Palliative - Improved Survival, 10000</P><P>Stuart Hen, Prostate Cancer, Curative, 18000</P><P>Ben One, Brain Cancer, Curative, 85000</P><P>Stuart Hen, Bone Cancer, Palliative - Improved Survival, 16900</P><P>];</P><P></P><P>Above is a simplistic example of the type of data that I am working worth. What I would like to do is to rank according to Diagnosis, then rank according to Treatment Intent in another table based on the Doctor selected.</P><P></P><P>I would need to fields of output, one which has the data ranked within the table, i.e. prostate cancer, bone cancer etc for that specific doctor and then the second field to rank the diagnosis overall, i.e. for that specific doctor the cost for prostate cancer was ranked against all doctors cost for prostate cancer.</P><P></P><P>Your assistance would be greatly appreciated.</P><P></P><P>Kind regards,</P><P>Bhavesh</P></BODY></HTML> Wed, 15 Sep 2010 13:29:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Assistance/m-p/201921#M59813 2010-09-15T13:29:57Z