Setting fields for both the X and Y axis

[#1]

Hi,

I am trying to show a trend in a chart that shows weeks waited for patients. So i need month and the bottom and weeks waited on the Y axis. How do i change this? This is my expression:

Sum ({$<Metric_Code={'RTT25'}>} Metric_Value)

and in the dimensions i have 'MonthYear'. If i put my weeks field in there is just creates a legend for weeks.

How do I put my weeks field on the Y axis?

Thanks,

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[#3]

This the chart now - but i need the Y axis to be in weeks not just number of patients ...?

[Anonymous]

Is Metric code RTT25 the numbers of weeks or number of patients? in your expression you should be suming or counting the weeks, so you have that in the axis.

[#5]

Its counting the patients, but even when I change my expression to count patients by week it doesn’t affect it:

So change it from:

Sum ({$<Metric_Code={'RTT25'}>} Metric_Value)

To: Sum ({$<Metric_Code={'RTT25'}>} weeks_metric)

Metric RTT25 is just pulling patients that are on an inpatient waiting list at the hospital. Metric value is the count of patients, weeks metric is the number of weeks

??

Kate Hunter

Senior Information Analyst

Planned Care Team

Derby Hospitals NHS Foundation Trust

Level 5

Tel: 01332 786745

Ext: 86745

[Anonymous]

If weeks_metric contains the number of weeks waited by patient, the second expression is right, can you upload your QlikView workbook to take a look?