topic Re: Get unique values ​​in a field in a model in a script in App Development https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2487209#M101489 <P><SPAN>Kudos nice simple solution!!</SPAN></P> Tue, 15 Oct 2024 23:45:40 GMT seanbruton 2024-10-15T23:45:40Z Get unique values ​​in a field in a model in a script https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2486397#M101387 <P>For example, I have 1000 tables in the model with the field Field1 and I want to get unique values ​​from this field from all tables (from the model).<BR />For example, I will need to write these values ​​to the qvd table.<BR />How can I do this without accessing each table?</P> Thu, 10 Oct 2024 12:06:33 GMT https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2486397#M101387 NikVladi 2024-10-10T12:06:33Z Re: Get unique values ​​in a field in a model in a script https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2486422#M101393 <P>Something like below...</P> <DIV>Sales:</DIV> <DIV>Load * Inline</DIV> <DIV>[</DIV> <DIV><SPAN> Country, SALED</SPAN></DIV> <DIV>&nbsp; &nbsp; UK, 100</DIV> <DIV>&nbsp; &nbsp; USA, 200</DIV> <DIV>&nbsp; &nbsp; INDIA, 150</DIV> <DIV>&nbsp; &nbsp; FRANCE, 400</DIV> <DIV>&nbsp; &nbsp; CANADA, 125</DIV> <DIV>];</DIV> <DIV>&nbsp;</DIV> <DIV>Country:</DIV> <DIV>Load * Inline</DIV> <DIV>[</DIV> <DIV><SPAN> Country, CONTINENT</SPAN></DIV> <DIV>&nbsp; &nbsp; UK, EUROPE</DIV> <DIV>&nbsp; &nbsp; FRANCE, EUROPE</DIV> <DIV>&nbsp; &nbsp; USA, NORTH AMERICA</DIV> <DIV>&nbsp; &nbsp; CANADA, NORTH AMERICA</DIV> <DIV>&nbsp; &nbsp; INDIA, ASIA</DIV> <DIV>&nbsp; &nbsp; CHINA, ASIA</DIV> <DIV><SPAN> AUSTRALIA, OCENIA</SPAN></DIV> <DIV>];</DIV> <DIV>&nbsp;</DIV> <DIV>Customer:</DIV> <DIV>Load * Inline</DIV> <DIV>[</DIV> <DIV><SPAN> Customer, Country</SPAN></DIV> <DIV>&nbsp; &nbsp; C1, INDIA</DIV> <DIV>&nbsp; &nbsp; C2, UK</DIV> <DIV>&nbsp; &nbsp; C3, INDIA</DIV> <DIV>&nbsp; &nbsp; C4, USA</DIV> <DIV>&nbsp; &nbsp; C5, CHINA</DIV> <DIV>&nbsp; &nbsp; C6, CANADA</DIV> <DIV>&nbsp; &nbsp; C7, NEW ZEALAND</DIV> <DIV>];</DIV> <DIV>&nbsp;</DIV> <DIV>For Each vCountry in FieldValueList('Country')</DIV> <DIV>&nbsp;</DIV> <DIV><SPAN> Trace $(vCountry);</SPAN></DIV> <DIV><SPAN> COUNTRY:</SPAN></DIV> <DIV><SPAN> Load&nbsp;</SPAN></DIV> <DIV><SPAN> '$(vCountry)' as Country&nbsp;</SPAN></DIV> <DIV><SPAN> Autogenerate 1;</SPAN></DIV> <DIV>&nbsp;</DIV> <DIV>Next vCountry</DIV> <DIV>&nbsp;</DIV> <DIV>Store COUNTRY INTO [$(vLocation)/COUNTRY_FIELD.qvd](QVD);</DIV> <DIV>Drop Table COUNTRY;</DIV> <DIV>&nbsp;</DIV> <DIV>Drop Table Sales;</DIV> <DIV>Drop Table Customer;</DIV> <DIV>Drop Table Country;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> Thu, 10 Oct 2024 14:08:53 GMT https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2486422#M101393 MK_QSL 2024-10-10T14:08:53Z Re: Get unique values ​​in a field in a model in a script https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2487209#M101489 <P><SPAN>Kudos nice simple solution!!</SPAN></P> Tue, 15 Oct 2024 23:45:40 GMT https://community.qlik.com/t5/App-Development/Get-unique-values-in-a-field-in-a-model-in-a-script/m-p/2487209#M101489 seanbruton 2024-10-15T23:45:40Z