Hi Support
Sometimes we have to use ADDNullXY to add null values to our charts. Looking at the chart it is correct but when it is exported or when the values are looked at on the Data tab there are "zeros" for the NULL values.
How can these values be replaced with NULL? We do not want zero's because when data is exported it is not possible to distinguish between real zeros and NULLs.
Thanks
JC
NULL values
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
Hi JC,
Which TeeChart version are you using? In v7 and v8 null values preserve they original values and their color is set to be transparent (clNone).
Which TeeChart version are you using? In v7 and v8 null values preserve they original values and their color is set to be transparent (clNone).
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
Instructions - How to post in this forum |
Hi Narcís
Thansk for your reply!
We are using V7.
We pass a zero to the AddNullXY function and that is the reason for the zeros when the data must be exported.
Example:
If data is displayed on a chart per half hour (there must be a value every 30 minutes) between 00:30 and 06:00,
*data is available from 00:30 to 02:30; 04:00 to 06:00
*data missing for 03:00 and 03:30
If no AddNullXY value is inserted for the missing values a straight line will be drawn between 02:30 and 04:00 - this is not correct because there are not any values available for 03:00 and 03:30.
If AddNullXY is used for 03:00 and 03:30 and Y is 999, the chart will look correct because of a gap between 02:30 and 04:00 but if the data is exported 03:00 and 03:30 will have values of 999 but should (in our case) be NULL.
I hope the example gives you a better idea of the problem.
Regards,
JC
Thansk for your reply!
We are using V7.
We pass a zero to the AddNullXY function and that is the reason for the zeros when the data must be exported.
Example:
If data is displayed on a chart per half hour (there must be a value every 30 minutes) between 00:30 and 06:00,
*data is available from 00:30 to 02:30; 04:00 to 06:00
*data missing for 03:00 and 03:30
If no AddNullXY value is inserted for the missing values a straight line will be drawn between 02:30 and 04:00 - this is not correct because there are not any values available for 03:00 and 03:30.
If AddNullXY is used for 03:00 and 03:30 and Y is 999, the chart will look correct because of a gap between 02:30 and 04:00 but if the data is exported 03:00 and 03:30 will have values of 999 but should (in our case) be NULL.
I hope the example gives you a better idea of the problem.
Regards,
JC
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
Hi JC,
Thanks for the information.
First of all please notice that TeeChart Pro ActiveX is a COM wrapper of TeeChart Pro VCL. This means that in VCL null values doesn't exist and thus null values can be saved. In that case you should check if point's color is clNone or you could even add a label to the point saying something like "NULL" so that points are clearly marked as null, for example:
It may also help you using something like in the All Features\Welcome!\Chart Styles\Financial\Candle (OHLC)\Axis Labels no Weekends example at the features demo. You'll find the demo at TeeChart's program group.
Hope this helps!
Thanks for the information.
First of all please notice that TeeChart Pro ActiveX is a COM wrapper of TeeChart Pro VCL. This means that in VCL null values doesn't exist and thus null values can be saved. In that case you should check if point's color is clNone or you could even add a label to the point saying something like "NULL" so that points are clearly marked as null, for example:
Code: Select all
TChart1.Series(0).AddNullXY X, Y, "NULL"
Hope this helps!
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
Instructions - How to post in this forum |
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
Hi JC,
As I told you, setting values to NULL is not possible as this type is not available. Regarding leaving them blank, you can create a non-visible dummy series where you add all values except the null ones and then only export those series.
As I told you, setting values to NULL is not possible as this type is not available. Regarding leaving them blank, you can create a non-visible dummy series where you add all values except the null ones and then only export those series.
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
Instructions - How to post in this forum |
Hi Narcís,
Sorry for only getting back to you now.
If you create a non-visible series as you suggest the value will not be exported correctly in our case. If there should be a value every thirty minutes and one value is missing there will be no “place holder” for that value – at first glance you will not see that there is a value missing, you will have to go and check each data/time value to make sure they follow one another correctly.
I think this will be a great enhancement to TeeChart and would like you to consider changing AddNullXY function to have a NULL value.
Kind Regards
JC
Sorry for only getting back to you now.
If you create a non-visible series as you suggest the value will not be exported correctly in our case. If there should be a value every thirty minutes and one value is missing there will be no “place holder” for that value – at first glance you will not see that there is a value missing, you will have to go and check each data/time value to make sure they follow one another correctly.
I think this will be a great enhancement to TeeChart and would like you to consider changing AddNullXY function to have a NULL value.
Kind Regards
JC
-
- Site Admin
- Posts: 14730
- Joined: Mon Jun 09, 2003 4:00 am
- Location: Banyoles, Catalonia
- Contact:
Hi JC,
As I told you in my previous reply, this is not possible because NULL value is not available in VCL (notice that TeeChart Pro ActiveX is a COM wrapper of the VCL version).
The only solution I can think of is that you manually export your series data and process null values as desired.
As I told you in my previous reply, this is not possible because NULL value is not available in VCL (notice that TeeChart Pro ActiveX is a COM wrapper of the VCL version).
The only solution I can think of is that you manually export your series data and process null values as desired.
Best Regards,
Narcís Calvet / Development & Support Steema Software Avinguda Montilivi 33, 17003 Girona, Catalonia Tel: 34 972 218 797 http://www.steema.com |
Instructions - How to post in this forum |