I think you are over complicating your chart. Here is what I'd suggest:
1. Calculate Month as a data field (in your load script)
2. In your scatter chart, use Month as a Dimension
3. Two expressions are:
As a side comment, I'd say that any date-related charts are viewed better as a time trend. In order to visualize the correlation between the number of sales people and sales, I'd create a Combo chart with Month as a dimension, and the two expressions presented in Bars and a Line - both trends will be easily recognized and the correlation could be easily traced.
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Austin, Texas and Johannesburg, South Africa!
Thanks for your reply,
I really like your approach.Yes, A combined line and Bar chart over months will surely give me desired results.
My intention is to see that over different months, Sales persons try contact their customers, I want to see if no of contact made has any affect on total revenue.
No time line is not my concern.
I want to conclude that if say in month Jan , people contacted 20 customers their revenue is say 4000 , similarly for each month I have different set of count and Sales...so I would have sort of 2 continuous dimensions, Count and Sales.
Different sets will give me different bubbles..this is my requirement...I want different combinations of Counts and Sales