topic Scatter plot quarter to date vs total year in QlikView

Scatter plot quarter to date vs total year

Fri, 05 Dec 2014 15:17:22 GMT

Hello,

Let's say I have the following data:

Year	Quarter	Revenues
2010	Q1	678257
2010	Q2	537022
2010	Q3	576896
2010	Q4	565975
2011	Q1	698267
2011	Q2	492955
2011	Q3	407228
2011	Q4	429770
2012	Q1	549469
2012	Q2	441505
2012	Q3	596917
2012	Q4	451280
2013	Q1	507712
2013	Q2	488299
2013	Q3	677729
2013	Q4	554149

Now I want a scatter plot displaying the cumulative sum of the revenues until the selected quarter per year versus the total revenues per year. Thus, if I have selected quarter 2, I want a scatter plot like the one in the attachment. I guess I have to use set expressions, but I don't know what this expressions should be. Please, can you help me with this?

Re: Scatter plot quarter to date vs total year

Sat, 06 Dec 2014 17:25:21 GMT

Hi Bart,

Please see the attached Scatter chart. This will allow you flex the quarters that are used for the chart by using the list box.

The Quarters that are selected will display along the axis to make it clear to the user what they are looking at.

Is this what you are looking for?

Re: Scatter plot quarter to date vs total year

Mon, 08 Dec 2014 08:17:20 GMT

Yes, that's exactly what I wanted. Thanks.