Please see attached app. You will the screenshot of the chart we would like to replicate. It's a chart that shows both monthly and quarterly performance (quarterly scores are the bars on the chart, the monthly data is on the line).
We have brought through raw data too.
Be amazing if this could be replicated the chart on this app in Qlikview..?
I have tried to create a chart but wasnt working. To avoid confusion I have removed it.
Tried to take on board comments and created a conjoined 'quarter-month' field in the data source; however, chart is still not seperating 'month' form the 'quarter' scores - its showing the same values.
Hi Chris, I see that [PI2. Overall sat with service] has the same data values for each month in the same quarter, and seems that this data is loaded from xls.
Sorry please see figures updated. The values change each month; however, will be the same for the respective (i.e the quarter score is the average of the 3 months individual values). I have updated table in app to show as a pivot table which then identifies how the values work and what we are trying to show.
The quarter block needs to be same for 3 months with the calcualtion being avg of Q1, avg of Q2 etc.
I realise I have amde this error when raising the question.. thanks for picking up.
