https://community.qlik.com/t5/Suggest-an-Idea/FirstValue-should-have-a-lower-RAM-memory-consumption/idi-p/1871909 <P>Hello all,<BR /><BR />FirstValue is a very useful aggregation&nbsp; function to take the first result of your data set. However, I had today a big issue with this function.<BR /><BR />Context : 256 GB RAM Server with 16 CPU<BR />67 millions row<BR />First Value on 8 fields (going from 67 millions row to 60 millions row)<BR /><BR />The reload takes more than half of RAM !!<BR /><BR />here is my code :</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="c">NoConcatenate FACT_Tx_Article_Histo : LOAD article_reference, article_date, text(FirstValue(ddj)) as ddj, num(FirstValue(pmp)) as pmp, num(FirstValue(taux_depreciation)) as taux_depreciation, text(FirstValue(enjeu_commercial)) as enjeu_commercial, //v1.3.0.0 - ajout de 5 champs text(FirstValue(modele_code)) as modele_code, text(FirstValue(article_ean13)) as article_ean13, //ok text(FirstValue(modele_description)) as modele_description, //ok num(FirstValue(article_pcb)) as article_pcb, text(FirstValue(article_statut)) as article_statut, num(FirstValue(supplier_type)) as supplier_type //plante si on le met en place sur l'ensemble de la volumétrie mais pas sur un échantillon... pourquoi? Resident TMP_FACT_Tx_Article_Histo_Step1 group by article_date, article_reference order by article_date,article_reference ,supplier_type ;</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="simonaubert_0-1639648764578.png" style="width: 804px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/68706iA4FADE2465F2089B/image-dimensions/804x203?v=v2" width="804" height="203" role="button" title="simonaubert_0-1639648764578.png" alt="simonaubert_0-1639648764578.png" /></span></P> <P>&nbsp;</P> <P>It seems to have a threshold effect since if I don't take supplier_type on, it works perfectly fine ( num type field with only two value 1 and 2) .<BR /><BR /><BR />Best regards,<BR /><BR />Simon</P> Thu, 16 Dec 2021 10:12:37 GMT simonaubert 2021-12-16T10:12:37Z https://community.qlik.com/t5/Suggest-an-Idea/FirstValue-should-have-a-lower-RAM-memory-consumption/idc-p/2100381#M13643 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/281760" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 15:31:13 GMT https://community.qlik.com/t5/Suggest-an-Idea/FirstValue-should-have-a-lower-RAM-memory-consumption/idc-p/2100381#M13643 Meghann_MacDonald 2023-08-02T15:31:13Z https://community.qlik.com/t5/Suggest-an-Idea/FirstValue-should-have-a-lower-RAM-memory-consumption/idc-p/2100382#M13644 Wed, 02 Aug 2023 15:31:15 GMT https://community.qlik.com/t5/Suggest-an-Idea/FirstValue-should-have-a-lower-RAM-memory-consumption/idc-p/2100382#M13644 Ideation 2023-08-02T15:31:15Z