Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying a do a very basic scatter chart in Qlikview, I don't need any calcuated fields I just need to present two fields as a scatter chart, as you would in Excel and am having problems.
Thank you, we are really stuck!!!
Since both axes are numeric, you need expressions to define them. If you do not use expressions, QlikView will assume the Only-function.
I suspect you should use the following two expressions:
* Only(Year) - or Min(Year); Max(Year), ...
* Sum(Cost)
And then you need a field as dimension - this is the field thet defines how many dots/bubbles you will get. If you want one dot/bubble per Product, then Product should be your dimension.
Do you have an example to post?
Thanks Henric, I have had a go but still cannot get it to work, (I am a very new user!)
Would it be possible for me to upload an Excel file with some dummy data so you see what I mean?
Year | Cost |
---|---|
2002 | 5000 |
2002 | 2000 |
2003 | 2500 |
2004 | 6000 |
2005 | 3050 |
2006 | 1000 |
2006 | 50 |
2006 | 2500 |
2006 | 3000 |
2007 | 35600 |
I have put some sample data in above. I need to show a bubble for each cost, not multipled together for the year but each separate cost showing as a separate entry at the appropiate size for the year. Is this possible?
Thanks for your help.
Hi,
It is possible if you use cost as dimension.
Celambarasan
Thanks everyone for your answers. We have finally done it!
For a scatter chart you need one dimension (discrete values) and two measures (numbers; continuous values).
For a grid chart you need two dimensions and one measure. So my first question is - which of the two do you want? (See attachement with your sample data.)
The second question is: Do you have an additional field that you can use in the chart? I added a mock-up "Product" and a mock-up "Profit" to your data. Su my grid chart has Year and Product as dimensions, and my scatter chart has Cost and Profit as measures.