https://community.qlik.com/t5/Talend-Studio/Getting-Started-with-tSetGlobalVar-and-tJavaRow-components/m-p/2297652#M70203 1. If you mean the value example, because it's a string. You can put any expression you want there. <BR />3. To retrieve, use the expression: (YourDataType)globalMap.get("YourVariableName") e.g. (Integer)globalMap.get("Counter") <BR />2. For example: ((Integer)globalMap.get("Counter"))==null?1 <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span>Integer)globalMap.get("Counter")+1 Thu, 04 Mar 2010 03:11:23 GMT alevy 2010-03-04T03:11:23Z https://community.qlik.com/t5/Talend-Studio/Getting-Started-with-tSetGlobalVar-and-tJavaRow-components/m-p/2297651#M70202 I 'd like to count non empty fields of a column from a sql table<BR />Question 1 : why , when i want to add tSetGlobalVar , the example is between quotes ? i only want to initialise a integer variable to 0.<BR />Question 2 : <BR />how add 1 to this variable when the field is not null ?<BR />Question 3 : how display this variable ? <BR />Thanks in advance Sat, 16 Nov 2024 13:31:26 GMT https://community.qlik.com/t5/Talend-Studio/Getting-Started-with-tSetGlobalVar-and-tJavaRow-components/m-p/2297651#M70202 jeanphi45 2024-11-16T13:31:26Z https://community.qlik.com/t5/Talend-Studio/Getting-Started-with-tSetGlobalVar-and-tJavaRow-components/m-p/2297652#M70203 1. If you mean the value example, because it's a string. You can put any expression you want there. <BR />3. To retrieve, use the expression: (YourDataType)globalMap.get("YourVariableName") e.g. (Integer)globalMap.get("Counter") <BR />2. For example: ((Integer)globalMap.get("Counter"))==null?1 <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MPcz.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157233iD1A564EF62DE3BC2/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MPcz.png" alt="0683p000009MPcz.png" /></span>Integer)globalMap.get("Counter")+1 Thu, 04 Mar 2010 03:11:23 GMT https://community.qlik.com/t5/Talend-Studio/Getting-Started-with-tSetGlobalVar-and-tJavaRow-components/m-p/2297652#M70203 alevy 2010-03-04T03:11:23Z