Hello Qlikers,
I have a question how to create a scatter chart with calculated dimension which is an average value of QoI for each stock number. I want to create a scatter chart in QV as it shown below which was created using an excel . It is an AVERAGEIF function that calculates the average QoI value for each stock number across all items. This table is what I want to plot overtime.
Thanks for your help
Wossen
Stock Number | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |
Average | 4.25618 | 4.16307 | 4.130081 | 4.12 | 4.130719 | 4.09894 | 4.171315 | 4.137931 | 4.137755 | 4.132184 | 4.131034 | 3.985185 | 4.05042 | 4.09375 | 4.22807 | 4.258065 | 4.384615 | 4.583333 | 4.6 | 5 | 4.666667 | 4.166667 | 4.75 | 4 | 4 |