Home | Sign in | English Help WLanguage WLanguage functions Controls, pages and windows Pivot Table functions Prefix syntax CalculateUpdate Presentation Example Calculation mode When to use .CalculateUpdate? See also AxisXY CalculateAll (function) CalculateUpdate Collapse CollapseAll Expand ExpandAll Filter HeaderValue InfoXY ListPositionHeader Load Save Select SelectCount ToExcel Functions for managing Pivot Table controls (prefixed syntax)
 Calculation modeWhen to use .CalculateUpdate? WINDEV WEBDEV WINDEV Mobile Others .CalculateUpdate (Function) In french: .CalculeMiseAJour Updates some of the data found in a Pivot Table control from a given date. Remarks: The content of the Pivot Table control was previously loaded into memory using .Load. The Pivot Table control includes a Date column, row or display filter.Example // Builds the file namesFile = SysDir(srAppData) + ["\"] + "StatsByCountry.tcd" // The file exists?IF fFileExist(sFile) THEN // Yes, load it PVT_Statistics.Load(sFile) // Update the Pivot Table control from the last calculation date // (we assume that the records associated with an earlier date // have not been modified) PVT_Statistics.CalculateUpdate(LoadParameter(DATE_LAST_CALCULATION))ELSE // The file does not exist, calculate it PVT_Statistics.CalculateAll()END Syntax .CalculateUpdate([]) : Control nameName of Pivot Table control to use. : Optional character string or Date variableDate from which the content of the Pivot Table control must be recalculated. This date must be in "YYYYMMDD" format. All the records associated with a Date item whose content corresponds to a date greater than will be taken into account.If this parameter is not specified, the date taken into account corresponds to the maximum date of the last result calculated or read by .Load.Remarks Calculation modeThe records taken into account for the re-calculation have the following characteristics: The records include a Date item. The content of the Date item is greater than or equal to the value of . The former values found in the Pivot Table control (if any) are deleted from the Pivot Table control from .The calculation can be quite long if an important volume of data must be read. In this case, a progress bar is displayed in the control.At the end of calculation, the new Pivot Table is displayed. Then, the result can be saved by .Save.When to use .CalculateUpdate?.CalculateUpdate must be used when the data is fixed: invoices for example. You only have the ability to add new invoices. In this case, the recalculation date corresponds to the date on which the content of the Pivot Table control was saved. If the data displayed in the Pivot Table control is modifiable (a quantity, a price, etc.), you must:: entirely recalculate the Pivot Table control. recalculate the Pivot Table control from the date corresponding to the modified record.Component: wd260obj.dll Minimum version required Version 23 This page is also available for…
{"ft_lang_label":"__label__en","ft_lang_prob":0.7867614,"math_prob":0.88203794,"size":746,"snap":"2021-31-2021-39","text_gpt3_token_len":174,"char_repetition_ratio":0.10377359,"word_repetition_ratio":0.0,"special_character_ratio":0.2386059,"punctuation_ratio":0.114285715,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.9707724,"pos_list":[0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102],"im_url_duplicate_count":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2021-08-03T04:50:49Z\",\"WARC-Record-ID\":\"<urn:uuid:91091aca-d4aa-4539-bb4b-577f1a5c7b12>\",\"Content-Length\":\"152981\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:fd51a4e9-92e5-4d89-8e0b-f6e944ce8c8d>\",\"WARC-Concurrent-To\":\"<urn:uuid:5e77f8fd-6516-4236-a400-b38b0530972b>\",\"WARC-IP-Address\":\"188.165.60.131\",\"WARC-Target-URI\":\"https://doc.windev.com/en-US/?1000022179&name=%3Cpivot_table%3Ecalculateupdate_function&product=ER\",\"WARC-Payload-Digest\":\"sha1:7FZJUXOZQOMFONPK2GFSBCS7THJ6DYYL\",\"WARC-Block-Digest\":\"sha1:RCGPI7CURVOKT27BBQWDW2RY7VC6Q467\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2021/CC-MAIN-2021-31/CC-MAIN-2021-31_segments_1627046154420.77_warc_CC-MAIN-20210803030201-20210803060201-00033.warc.gz\"}"}