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: 
Not applicable

Problem with scatter chart with invalid coordinates

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.

error loading image

(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.

error loading image

--> my chart is OK.

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

error loading image

--> 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.

error loading image

--> My chart is OK.

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

error loading image

--> 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...

0 Replies