Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wossenhh
Creator
Creator

Creating Scatter Chart

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 Number12345678910111213141516171819202122232425
Average4.256184.163074.1300814.124.1307194.098944.1713154.1379314.1377554.1321844.1310343.9851854.050424.093754.228074.2580654.3846154.5833334.654.6666674.1666674.7544

 

Schart.png

0 Replies