A funnel plot chart QlikView sample attached, with the sample data behind it in Excel.
1. It is a line chart, with a scatter chart overlaid.
2. Most of the work is done in the load script, data is just presented in the chart.
3. For the Upper and Lower limit lines, make sure the use a continuous axis, to get the smooth lines.
I'm trying to achieve a similar chart to this.
I want A&E attendances along the bottom and % performance on the y axis and dots to be the trusts.
I want to put the upper and lower limits as expressions and not in the script.
How can I do this?
I tried it as scatter graph and then tried it as a line chart as suggested, but still couldnt get anywhere.
Any help would be appreciated.
Thank you in advance.