Problem with scatter chart with invalid coordinates

Mon, 28 Feb 2011 13:06:21 GMT

Good day,

I'm using QlikView 9 SR 6.

I have problems in my application when I want to display a scatter chart having invalid coordinates.

Let's say I have values for each month from january 2010 to december 2011.


TableData:
LOAD * INLINE [
 Product, MyDate, Value, X, Y
 Water, 01/01/2010, 1, 1, 1
 Water, 01/02/2010, 2, 1, 1
 Water, 01/03/2010, 3, 1, 1
 Water, 01/04/2010, 4, 1, 1
 Water, 01/05/2010, 5, 1, 1
 Water, 01/06/2010, 6, 1, 1
 Water, 01/07/2010, 7, 1, 1
 Water, 01/08/2010, 8, 1, 1
 Water, 01/09/2010, 9, 1, 1
 Water, 01/10/2010, 10, 1, 1
 Water, 01/11/2010, 11, 1, 1
 Water, 01/12/2010, 12, 1, 1
 Water, 01/01/2011, 13, 1, 1
 Water, 01/02/2011, 14, 1, 1
 Water, 01/03/2011, 15, 1, 1
 Water, 01/04/2011, 16, 1, 1
 Water, 01/05/2011, 17, 1, 1
 Water, 01/06/2011, 18, 1, 1
 Water, 01/07/2011, 19, 1, 1
 Water, 01/08/2011, 20, 1, 1
 Water, 01/09/2011, 21, 1, 1
 Water, 01/10/2011, 22, 1, 1
 Water, 01/11/2011, 23, 1, 1
 Water, 01/12/2011, 24, 1, 1
];

DimDate:
LOAD
 DISTINCT MyDate AS DimDate
RESIDENT TableData
ORDER BY MyDate;

I can have my evolution using the formula


sum(if(MyDate = DimDate, Value)) / sum(if(MyDate = addmonths(DimDate, -12), Value))

When I display the values in a chart, I have a "-" when the ratio cannot be calculated.

(this is the expected result)

Now, let's say I want to use this ratio as a coordinate in a scatter chart.
If my scatter chart is opened and I select dates that cannot return results, my application become buggy.

Step 1 : Scatter chart is minimisez. I select 3 dates that will produce a correct ratio.

--> my chart is OK.

Step 2 : I select 3 dates that will make a division by zero

--> my chart is OK (I have a "-" displayed)

Step 3 : I select 3 dates that will produce a correct ratio. I open the scatter chart.

--> My chart is OK.

Step 4 : I select 3 dates that will make a division by zero

--> all my data are wrong.

If my application is on a remote server, this produce a "server connection lost".

I think this is a bug...

topic Problem with scatter chart with invalid coordinates in QlikView

Problem with scatter chart with invalid coordinates