41 Replies Latest reply: Feb 19, 2016 3:51 AM by Friedrich Hofmann RSS

    Trouble synchronizing the figures displayed in different objects ...

    Friedrich Hofmann

      Hi,

       

      I have, in an app I am currently building, two objects:

      - A straight_table chart and

      - a gauge_chart

      and I am trying to synchronize them in that they should display as exactly as possible the same figures.

      Logical, isn't it?`Sounds easy, too - well, so one should think ...

       

      It is not. The figures were even quite far apart. I have by now removed one calculated dimension from the chart that the gauge did not have and removed the tick "suppress NULL values" for another dimension and realized that the figures came closer.

      To do that, I calculated a flag_field in one of my tables to tell whether or not a specific record in the table is linked to any in the other table. I used an EXISTS() function for that to check whether the keyfield used to link the two tables exists in a copy of the keyfield in the other table. That seems to work quite well.

       

      Now, the figures are quite close - the chart shows a final ratio of 71.33 % and the gauge shows 70.2 % which isn't bad - but still not ideal if there is any way to fix it. That can't be rounding errors - well, several rounding errors could stack up to that difference ...

       

      Can you tell me what that could be due to?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler

        • Re: Trouble synchronizing the figures displayed in different objects ...
          jagan mohan rao appala

          Hi,

           

          In Straight table try like this

           

          Properties -> Expression -> Select Expression Total then it should match with the Gauge chart.

           

          Hope it helps you.

           

          Regards,

          Jagan.

          • Re: Trouble synchronizing the figures displayed in different objects ...
            Marcus Sommer

            Hi DataNibbler,

             

            the differences look a bit to high for rounding-differences - I would rather assume that your divisor slightly differ maybe because some empty or NULL value will be counted without a dimension-relation and ignored by using the dimension by enabling the hide-option on NULL values or something quite similar. I think if you separate those divisor in both expressions you will see a difference between them and with a few selections on various fields you could then localize the reason.

             

            - Marcus

              • Re: Trouble synchronizing the figures displayed in different objects ...
                Friedrich Hofmann

                Hi Marcus,

                 

                yep. I've spotted what is a likely enough reason - that'as another point where I have actually not kept the standard I have mentioned in my above post ...

                There is an IF() construct in all of my dimensions (always the same), in addition to the "suppress NULL" ticks in two of them - it goes like

                >> IF(Art_Lager <> 'nonexistent', [dimension] <<

                 

                => Now I have to put this into a SET_expression that I can implement in the expressions that my gauge works on.

                Before, it was

                >> COUNT(DISTINCT Track) <<

                So I guess now it has to be

                >> COUNT({$<Art_Lager = {"$(= '<>' & 'nonexistent')"}>} DISTINCT Track) <<

                 

                Right? I know that could be written more elegantly, but then the expression_editor doesn't recognize it anymore and underlines it ...

                  • Re: Trouble synchronizing the figures displayed in different objects ...
                    jagan mohan rao appala

                    Hi,

                     

                    Try this

                     

                    COUNT({$<Art_Lager -= {'nonexistent'}>} DISTINCT Track)

                    It will show error new -= but it works.

                     

                    Regards,

                    Jagan.

                    • Re: Trouble synchronizing the figures displayed in different objects ...
                      Marcus Sommer

                      The syntax-highlighter isn't always correct - if your expression worked you could ignore the error-message.

                       

                      - Marcus

                        • Re: Trouble synchronizing the figures displayed in different objects ...
                          Friedrich Hofmann

                          Hi Marcus,

                           

                          yes, of course I could ignore it ...

                          Then I'll just have to put a comment directly in the expression about this. Still I'd rather not, but I'll try out lateron.

                           

                          Okay. This works - now it's down to 1 item difference which makes for a difference in ratio which will probably not show with just 2 decimal places ... I wonder where that is - I don't have any dimensions or stuff where 1 item is different from all the rest ...

                            • Re: Trouble synchronizing the figures displayed in different objects ...
                              Friedrich Hofmann

                              Hi,

                               

                              now I have a different problem - well, it's the same, kind of ...

                              The numbers of items (the two numbers that make up my ratio) are now the same between the table_chart and the gauge - one differs by 1, but I guess that can be ignored ... And the ratio is 70.15% (I have recalculated it) and the gauge correctly shows 70.2% - the table_chart, however, shows a ratio of 71.33%.

                              Can that be due to rounding? I guess it can - the expression in the chart is of course calculated for every single line and that figure on top is the average.

                              • Re: Trouble synchronizing the figures displayed in different objects ...
                                Marcus Sommer

                                Hi DataNibbler,

                                 

                                the reason could be that you counts a keyfield or that there is any empty field-value - often you find this only with a tablebox of your fields and reducing the dataset by various selections to exclude those data-areas which are fitting until you comes to those where the unexpected must be and there are less enough data to check them manually.

                                 

                                - Marcus

                                  • Re: Trouble synchronizing the figures displayed in different objects ...
                                    Friedrich Hofmann

                                    Hi Marcus,

                                     

                                    yes, a tablebox is usually the best way to find those little bugs. However, right now I have other more pressing things to do - to be honest, it is mainly me striving to get this 100% correct, nobody else will really care about 1% more or less - not in this matter and also because there are many more factors to do with the underlying data because of which the data shown in this app can never be absolutely correct anyway.

                                    I'll close this thread now, but I guess I will have another look at this when there is time - some time in Q3 maybe ...

                                     

                                    Best regards,

                                     

                                    dataNibbler

                                      • Re: Trouble synchronizing the figures displayed in different objects ...
                                        Friedrich Hofmann

                                        Hi Marcus,

                                         

                                        sorry to bring this up again when it's already kind of solved - I think somebody here once told me a way (I think it was you) to build a set_expression identical in effect to that > -= < construct which the editor does recognize - that has the advantage that the editor does not stop checking any syntax at that point, but it also checks the subsequent statements.

                                        I tried, it was something like (an expression in the set_expression) >> $(= '<>' & [not_wanted_value]) << - well, almost, but that does not work. Say I want to replace the working set_expression >> Art_Lager -= {'nonexistent'} <<

                                         

                                        Thanks a lot!

                                        Best regards,

                                         

                                        Datanibbler

                                          • Re: Trouble synchronizing the figures displayed in different objects ...
                                            Marcus Sommer

                                            Hi DataNibbler,

                                             

                                            no, I wasn't it then I would use simply the not recognized syntax of -=. I could imagine that there are possibilities with '<>' syntax, maybe something with two sets like:

                                             

                                            < Art_Lager = {'*'} > - < Art_Lager = {'nonexistent'} >

                                             

                                            but I would rather use a function  like:

                                             

                                            < Art_Lager = {"$(=if(match(Art_Lager, 'nonexistent'), false(), true()))"} >

                                             

                                            - Marcus

                                              • Re: Trouble synchronizing the figures displayed in different objects ...
                                                Friedrich Hofmann

                                                Well, that doesn't seem to work. I will keep on trying, however. The editor stopping at that statement and not checking the potentially long remainder of an expression is just too annoying.

                                                 

                                                Best regards,

                                                 

                                                DataNibbler

                                                  • Re: Trouble synchronizing the figures displayed in different objects ...
                                                    Friedrich Hofmann

                                                    Hi,

                                                     

                                                    I'm still puzzled by the two objects in this app - a gauge and a table_chart - displaying different figures (the usage_rate of capacities in %).

                                                    The table_chart has a number of dimensions, but no "suppress NULL" ticked, no general limitations,

                                                    so I really wonder what can cause the table_chart to behave differently.

                                                     

                                                    Also, it seems that individual items - when I select just one row from that table_chart - it seems to be correct, the two objects then show the same - so it must be something about how QlikView  calculates that average - the formula in the table_chart calculating the usage_rate of every single line_item calculates using two of the previous expressions, something that can be done in table_charts to simplify the formulas.

                                                    There are of course capacities which are not used and thus have a rate of 0 - that enters into the average of course, but it also does so in the gauge, no?

                                                    There are other items which do not figure in our new Capacities_database and thus have no usage_rate at all - those do not enter into the average, do they?

                                                      • Re: Trouble synchronizing the figures displayed in different objects ...
                                                        Friedrich Hofmann

                                                        Now I have replicated the whole thing in Excel - I have exported the entire table_chart and then thrown out all those line_items which have no valid usage_rate at all because they don't figure in our database (they might be used acc. to our database, but as we don't have them in our file, they don't have a capacity, so strictly speaking, that would be a division by zero which QlikView just displays as a > - <.

                                                        => When I do that, the result is exactly the same that my table_chart displays - but the gauge shows a significantly

                                                             different usage_rate.

                                                         

                                                        => So the relevant question now is, whatever enters in the calculation of the gauge_chart that does not enter into the calculation of the table?

                                                         

                                                        P.S.: Another strange thing is also that, if I remember correctly, the last time round it was the gauge that showed the exact same figures as a "simple" recalculation in Excel, not the table_chart.

                                                          • Re: Trouble synchronizing the figures displayed in different objects ...
                                                            Marcus Sommer

                                                            Hi DataNibbler,

                                                             

                                                            in a normal chart with dimensions will be the $-sign expansion from the set analysis calculated once before the chart and then applied for each row respectively dimension-value. In this case you could try it without the $-sign expansion like:

                                                             

                                                            < Art_Lager = {"=if(match(Art_Lager, 'nonexistent'), false(), true())"} >

                                                             

                                                            but if this didn't worked you will need another approach. Differences between normal charts and gauges will be most often caused by the dimensions and you will probably need TOTAL's and/or aggr() within your expressions and sometimes also an error-handler to catch NULL or other unwanted values.

                                                             

                                                            - Marcus

                                                              • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                Friedrich Hofmann

                                                                Hi Marcus,

                                                                 

                                                                well, now I have removed all dimensions but one - the shelf_nr. from the database of shelves that we have built up.

                                                                With this dimension, the "Suppress NULL values" is ticked.

                                                                In the gauge_chart, I have a set_expression to essentially do the same - I have made a field in the script that is 1 if a shelf (as named in the real database) is listed in our new database and 0 otherwise - I have a set_expression querying this for the value 1.

                                                                => This done, the sum of shelf-capacity that is displayed in my table_chart is equal to that used in my gauge_chart

                                                                      (I have replicated the formulas used in the gauge_chart in a textbox) and the nr. of tracks (boxes) on these

                                                                      shelves is also equal

                                                                <=> Still, the average of the usage_rate in the table_chart (the usage_rate is calculated in every single line of the

                                                                       table_chart) is markedly different from what the gauge displays (and the gauge simply displays what I could

                                                                       calculate myself by just dividing the nr._of_boxes by the sum_of_shelf_capacity) so I guess the gauge shows

                                                                       the correct value.

                                                                Still, any single item that I select in the table_chart is calculated correctly and then the figures match those in the gauge_chart.

                                                                => Can it be that there are such large rounding errors? I will do some experimenting with just adding more decimal_places to the calculation in every single line and see if that makes the whole thing somewhat closer ...

                                                                  • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                    Marcus Sommer

                                                                    Rounding errors aren't rather involved - they make usually only quite smalI differences and I think you will need aggr-functions maybe nested ones maybe with TOTAL's and/or a NODISDINCT extension:

                                                                     

                                                                    avg(TOTAL aggr(avg(aggr( NODISTINCT ...

                                                                     

                                                                    you might need to play (systematically) a little bit with them.

                                                                     

                                                                    - Marcus

                                                                      • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                        Friedrich Hofmann

                                                                        Hi Marcus,

                                                                         

                                                                        thanks for the help!

                                                                        But - if there was something wrong with the dimensions (such that I would need to apply some aggr() functions or such with which I also don't have anything much in the way of experience) - would not that error necessarily show up in every single line, rather than just in the average (as I said, I can select any single item and the figures match exactly)?

                                                                        (the rounding really wasn't it, expanding the nr. of decimals didn't bring the figures any closer)

                                                                         

                                                                        I really cannot see anything in this whole business. It's a complete mystery to me.

                                                                        What is also strange, there is now only one dimension left - the shelf_line from the database of shelves we are just building. I have ticked the "Suppress NULL" checkbox, so any boxes in our real database booked to a place that is not in our shelf_database are not displayed.

                                                                        <=> In the gauge, I have that set_expression I have already posted, making use of a field that I calculate in the script.

                                                                              The field is like this (within a preceding LOAD):

                                                                                >> IF(EXISTS(Lagerreihe_vorhanden, Regalreihe), 1, 0) as Lagerreihe_in_Excel_DB_vorhanden <<

                                                                                (the field >> Lagerreihe_vorhanden << is in a table that was loaded earlier and the field >> Regalreihe << is the

                                                                                 rather complex calculated key that I build in the actual LOAD - that is why this is in a preceding LOAD.

                                                                        I will experiment a bit with this - maybe having this in a preceding LOAD is not right. Strangely, with this expression, the gauge shows the figure that one could calculate from the total SUM and COUNT - but when I remove it, it shows something completely different - again different from what the table_chart shows, so I have to deal with three different figures ...

                                                                         

                                                                        If that fails, I will try making a fake database with only about 10 or 20 items so I can recalculate it all manually to check it.

                                                                         

                                                                        Best regards,

                                                                         

                                                                        DataNibbler

                                                                         

                                                                        P.S.: I just realize there is an error in that field - quite a nr. of items that are actually present in our database are grey when I select the value >1< in that field. I have to look into why that happens. That should be quite unconnected with my other issue as I guess it affects both objects in the same way - but then, I cannot judge on this as it is completely misty to me ...

                                                                          • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                            Marcus Sommer

                                                                            Hi DataNibbler,

                                                                             

                                                                            if you struggled in this way in could be that the reason is caused through your datamodel (keys didn't fit) or within the data-quality. I would check this within a tablebox with a unique record-identifier (recno/rowno) and after that I would build a table-chart - at first with many details nearly on record-level and then consolidate them by reducing the details step by step respectively extend the expressions with totals to ignore the detail-levels.

                                                                             

                                                                            This will need some efforts but it's better to understand the data right and most often faster then trial and error on data which might be different then expected.

                                                                             

                                                                            - Marcus

                                                                              • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                Friedrich Hofmann

                                                                                Hi Marcus,

                                                                                 

                                                                                yes, I guess I have to dive into the very basis of this app once again. As I said, the key is quite complex, so it might well be that there is some error - because in that new database we have a mix of shelf-rows - with many so-called BINs - and other areas with just one - and in the real database we have only the BINs - so the key has to be different depending on the type of storage_area.

                                                                                For now, I have noticed that for those items that do not appear in the real database, that EXISTS() field does not work - selecting the value >1< in that field leaves that item grey even in the new database - so the gauge, because of the set_expression, does not consider those items at all while the table_chart - well, I see them appear with a value of 0, but it might be that I only see that and behind is something different that somehow messes up the figures.

                                                                                  • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                    Friedrich Hofmann

                                                                                    Hi Marcus,

                                                                                     

                                                                                    I have now checked all my keys - it's a bit difficult because all the storage_areas which, acc. to the system, are not in use, do not figure in the real database - so even if they are in the Excel_DB, the key does not match anything - but most items match, I've just tried a few from every type of storage_area there is in my Excel_DB.

                                                                                     

                                                                                    I'm still not much wiser - but I try to approach the issue step by step:

                                                                                     

                                                                                    I've realized that the flag_field I have created with Applymap() to show whether a storage_area is in our Excel_database does not quite work (same as the field I used to have with EXISTS()): The other table is from our working database, and many storage_areas that are not in use (acc. to the system) do not figure in the table - so for all these, that flagfield will also say "No" because the Applymap() cannot return a positive value even when a storage_area does figure in our Excel_database because there is simply nothing there to match.

                                                                                    => So a set_expression querying that flagfield for the value >1< will at the same time dismiss all storage_areas which, acc. to the system, are not being used.

                                                                                     

                                                                                    => The set_expression I have in the gauge does thus not have the same effect as the "Suppress NULL" checkbox in the table_chart.

                                                                                    Unless you know a better way, I guess I'll work with a trigger to just select all selectable values in the Excel_DB - that way I'll have all storage_areas listed there, used or not.

                                                                                     

                                                                                    I will now kind of start over and shrink a copy of the Excel_DB down to few records and see what I see - since every single item seems to match (between the table and the gauge) and the discrepancy is just in the top_line_average, that error must come in somewhere.

                                                                                      • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                        Marcus Sommer

                                                                                        Hi DataNibbler,

                                                                                         

                                                                                        I could imagine that the approach to link these data is rather inappropriate like in the common case that you have sales and no targets to them and reverse like in this example: Re: Budget Achievement and how you it turned something will be missing. That means you need a different approach like to concatenate those data (and create there your flags) or using of a bridge-table but this is more complicated and these bridge needs all distinct values.

                                                                                         

                                                                                        - Marcus

                                                                                          • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                            Friedrich Hofmann

                                                                                            Hi Marcus,

                                                                                             

                                                                                            I'm fed up with this. I cannot see anything in this matter since every single item seems to be right - e.g., it matches between the table_chart and the gauge - but the average of them all is wrong - the table_chart and the gauge show different values.

                                                                                            Also, I cannot use either EXISTS() or Applymap() to determine whether a shelf or area is in our new database because, when it is not in use, it's just not in the transaction_table in our real database, so the output of both these functions will be the same in cases a) (it's used, but not in our database) and b) (it's not used, whether or not it's in our database).

                                                                                            I will start over again now I guess, with a new approach at building the link between our new database and the transaction_table. And I will try a bridge_table that has all the areas - I could use that to determine whether one is in our new database. And there is one, only it is very irregularly maintained.

                                                                                            Let's see ...

                                                                                              • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                Friedrich Hofmann

                                                                                                Hi Marcus,

                                                                                                 

                                                                                                I think this is a mathematical thing - I'll ask my uncle, he worked as a physician and he knows it all ;-)

                                                                                                The thing is, if I select just three shelf-rows, I get two different results depending on

                                                                                                - whether I take the entire count of tracks and divide it by the total sum of spaces I have

                                                                                                - or I "manually" calculate the average of the percentage_values by adding up all the percentages and dividing them

                                                                                                   by their number - the way you usually go about calculating an average.

                                                                                                Only sometimes the one is higher and then the other.

                                                                                                Every item for itself is correct, so there must be something about calculating the average of percentages that just won't work.

                                                                                                => Might there be any way I can display something else, not calculated in that same column, but based on the totals of the other columns in the table_chart so I can have the correct number there?

                                                                                                 

                                                                                                P.S.: What does this formula_option "formula on all values" mean (the radio-box where I can also select the average of the y-values)?`Which formula is applied when I tick that?

                                                                                                    • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                      Friedrich Hofmann

                                                                                                      Hi Marcus,

                                                                                                       

                                                                                                      this was in the back of my head all the time. No, I think not - if I understand Henric's explanation correctly, the thing is actually quite logical - you have to take care of which granularity your data has and make that match the average you want - but that's just for when you calculate it yourself. But I think that has nothing to do with my mathematical problem.

                                                                                                      The difference is merely that in the company_database, the tracks are not booked on shelf_lots - those don't exist in the database. Instead they are booked on "BINs" and one BIN does not always correspond to one storage_lot - but through the choice of the key linking the two tables I have already taken care of that.

                                                                                                      However, I have put the question to him and I hope he can explain the underlying principle to me. In the meantime, I will rebuild my app which isn't bad because I can probably do one or two things better than I did the first time.

                                                                                                        • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                          Friedrich Hofmann

                                                                                                          Yippieh. Well, I still don't exactly understand why - I never liked mathematics and statistics - but at least I now have it from an expert that this second method of calculation is plain wrong, so I can now with a clear conscience take that display out of the table_chart and just leave my overall usage_gauge.

                                                                                                           

                                                                                                          Best regards,

                                                                                                           

                                                                                                          DataNibbler

                                                                                                            • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                              Friedrich Hofmann

                                                                                                              Hi Marcus,

                                                                                                               

                                                                                                              I think I'm going crazy over this stuff.

                                                                                                              I have built it all from scratch now and I think it's better than before. Still I have two very strange phenomena:

                                                                                                              - I have tables A (our new shelf_database in Excel) and B (the one from our real database).

                                                                                                              When I use a dimension_field from table_A and display a figure from table_A with a sum, the sum is right.

                                                                                                              <=> When I use a second dimension_field from table_B, the sum of the figures from table_A is suddenly different.

                                                                                                              => I removed that dimension_field. Never mind, it was not critical, now that seems ok. Must be because the key is

                                                                                                                   quite complicated and, to keep things legible step by step, it is built over about 7 PRECEDING LOADs. (do you think that is a problem? It should not ... at least, I have not yet found any items that are not properly linked.

                                                                                                               

                                                                                                              Another thing: I only have dimensions from table_A now. One of the expressions to display is a figure from table_B, the count of boxes on all the shelves and storage_areas. I have a sum on top of that column.

                                                                                                              Now, for I don't know what reason, a textbox with the calculations showed me 6 boxes less than my table_chart. I tried redoing the table_chart and got the same as in the textbox (those 6 less) - then I compared the formulas used in the two table_charts, they were the same, I copied the one from my first table_chart - and the figure jumped up 6 boxes ... I redid the chart another time and it was 6 less again ...

                                                                                                              I'm at my wits' end ... guess it would be best to go home now ;-)

                                                                                                                • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                                  Friedrich Hofmann

                                                                                                                  Okay,

                                                                                                                   

                                                                                                                  that second issue seems solved although I don't quite understand why - if I choose "formula on all values" instead of "sum of y values" for the figure on top of the column, I have those 6 boxes less and thus the same figure as in my textbox; So I assume this is the correct figure though I cannot understand why a cound on all values should be different from the sum of all the counts ...

                                                                                                                  • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                                    Marcus Sommer

                                                                                                                    Hi DataNibbler,

                                                                                                                     

                                                                                                                    I don't think that the many preceeding load are a problem. But I 'm not sure about your datamodel with a (like you said) complicated key. It could be very difficult to find here the reason why you have small differences (the bigger one are a lot easier to find and to fix). I would rethink the whole approach in the direction to minimize or even to avoid these complicated keys and to develop a star-scheme. This meant concatenate/joining/mapping the tables together as many as possible - quite often are the efforts lesser then to develop a link- or associated datamodel.

                                                                                                                     

                                                                                                                    - Marcus

                                                                                                                      • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                                        Friedrich Hofmann

                                                                                                                        Hi Marcus,

                                                                                                                         

                                                                                                                        yes, I get what you mean. The whole approach is kind of funny ...

                                                                                                                        The fact that a dimension_field from one table impacts the overall sum of a figure from another table can only mean that there is some issue about the key.

                                                                                                                        The trouble is that our real company_database does not know shelves or other storage_areas, only Bins. So I faced the challenge of linking our new storage_database to the Bin_names - now, at times, the Bin_name has 3 numeric elements, like xxx-xx-xx, so a shelf_number is the 1st of those numeric elements. At other times, the name of a storage_area is identical to the Bin_name. At other times, the name of a storage_area relates to the first two characters of many Bin_names, or the first four ...

                                                                                                                         

                                                                                                                        Also, we don't even have all the storage_areas there are in our new database yet, there is still a remainder, because many Bins that goods can be booked onto do not correspond to any physical area, but rather to the status of the goods, and there are at times several Bins that do correspond to a physical area - but only one, so the goods are not moved, but still booked from one Bin onto another.

                                                                                                                         

                                                                                                                        I cannot make it any easier, the system is not standardized - or there are about 15 different standards, as you prefer ...

                                                                                                                        I already use mapping_tables to avoid circular references and also to avoid having to hard-code lists of Bin_names in my script's formulas, instead using an Applymap(), and I try to reduce the nr. of tables  by joining. I will keep on trying.

                                                                                                                         

                                                                                                                        Best regards,

                                                                                                                         

                                                                                                                        DataNibbler

                                                                                                                          • Re: Trouble synchronizing the figures displayed in different objects ...
                                                                                                                            Marcus Sommer

                                                                                                                            Hi DataNibbler,

                                                                                                                             

                                                                                                                            yes it's quite difficult to handle or even to correct poor processes and/or poor data-quality. Probably there will be always some gaps but it is really helpful (especially in the long-term) to be able to show that gaps exists and maybe where they are and what caused they.

                                                                                                                             

                                                                                                                            This meant to make sure that each failure in linking or associating data and all missing data are assigned with a real value like 'NULL', 'MISSING', '#NV' and so on and maybe with adding an additionally number to be able to differentiate them even more. Further to have to have to all data the source from where it comes from and maybe a status like 'ok.' and 'not ok.' and if the amount of data aren't really huge to have to all data recno's and rowno's and to plot then those data into tableboxes. It's a lot easier to understand where the problems come from and also to be able to show it to others.

                                                                                                                             

                                                                                                                            - Marcus