{"id":40564,"date":"2018-11-14T17:30:01","date_gmt":"2018-11-14T12:00:01","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=40564"},"modified":"2018-11-14T17:30:01","modified_gmt":"2018-11-14T12:00:01","slug":"qlik-sense-table-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/","title":{"rendered":"Qlik Sense Table Functions With Syntax"},"content":{"rendered":"

1. Objective<\/span><\/h2>\n

In our last tutorial, we discussed Qlik Sense Trigonometric and Hyperbolic functions<\/a><\/strong>. Today, we will see Qlik Sense Table Functions. Moreover, the table functions are used to apply certain operations on the tables which the current LOAD statement is reading or evaluating. These functions make managing fields and data values in a table easy and convenient especially when a lot of data is being dealt with, in a single data load script.<\/span><\/p>\n

So, let’s start Qlik Sense Table Functions.<\/p>\n

\"Qlik<\/a>

Qlik Sense Table Functions With Syntax<\/p><\/div>\n

2. Qlik Sense Table Functions<\/h2>\n

i. FieldName() function<\/span><\/h3>\n

This function is used when you want to return the name of a field from a previously loaded table. You will have to specify the name of the table if you are using this function outside of the LOAD statement in which that particular table is been loaded. But if you are using this function within the piece of code which has the concerned table within the LOAD statement, you must not specify the table\u2019s name as it would be automatically understood by the system\u2019s logic.<\/span><\/p>\n

Have a look at Qlik Sense Logical Functions<\/a><\/strong><\/p>\n

The syntax of FieldName function:<\/strong><\/p>\n

FieldName(field_number ,table_name)<\/pre>\n
Where field_number is the number of the field in the table.<\/span><\/p>\n
And, table_name is the name of the table from which you want the function to find the field name through the field number. <\/span><\/p>\n
For instance, the piece of code given below uses the FieldName function to call the 2<\/span>nd<\/span> field i.e. Attribute field in the script statement. This is an example of using this function within the same LOAD statement as the table. <\/span><\/p>\n
LOAD *\r\nFieldName(2)\r\nInline [\r\nAttributeCode, Attribute\r\nR, Red\r\nY, Yellow\r\nB, Blue\r\nC, Cotton\r\nP, Polyester\r\nS, Small\r\nM, Medium\r\nL, Large\r\n];<\/pre>\n
If you want to use this function out of the same LOAD statement then it would be as given below. Which assigns the function as a variable x and calls the fieldname from tab1 at the fourth position.<\/span><\/p>\n
Let’s revise Qlik Sense Mathematical Functions<\/a><\/strong><\/p>\n
LET x = FieldName(4,'tab1');<\/pre>\n
ii. FieldNumber() function<\/span><\/h3>\n
The FieldNumber() function returns the number of the field in a table. This function can either be used within the LOAD script where the table is loaded or outside of it by calling the field and table in which the field resides. <\/span><\/p>\n
The syntax of Qlik Sense FieldNumber Function:<\/strong><\/p>\n
FieldNumber(field_name ,table_name)<\/pre>\n
Where <\/span>field_name<\/span><\/i> is the name of the field of which you want to know the number. And, <\/span>table_name<\/span><\/i> is the name of the table which contains the concerned field. <\/span><\/p>\n
For example, <\/span><\/p>\n
LET x = FieldNumber('Customer','Sales');<\/pre>\n
Suppose the field name \u2018Customer\u2019 mentioned in the sample code above is the 2<\/span>nd<\/span> field in the table \u2018Sales\u2019. Then this function would return 2. Note that we have mentioned the name of the table because we are using it out of the LOAD statement loading the table \u2018Sales\u2019. Although if you use this function within the LOAD statement for Sales table then mentioning the name in the function is not required. If no such field as you mentioned in the function is available in the table then 0 is returned.<\/span><\/p>\n
Do you know about Qlik Sense Mapping Functions<\/a><\/strong><\/p>\n
iii. NoOfFields() function<\/span><\/h3>\n
This function is used to return the total number of fields present in a table. <\/span><\/p>\n
The syntax of Qlik Sense NoOfFields function<\/span>:<\/span><\/p>\n
NoOfFields(table_name)<\/pre>\n
Where in place of table_name parameter, you must enter the name of the table of which you want to know the number of fields. However, if you are using this function within the LOAD statement in which the concerned table is been loaded then the name of the table is not required as the function\u2019s parameter. <\/span><\/p>\n
For example, if in a table called Sales, there are a total of 8 fields then we will use the NoOfFields() function as,<\/span><\/p>\n
LET x = NoOfFields(\u2018Sales\u2019);<\/pre>\n
Returns 8 as the value for the variable x. <\/span><\/p>\n
iv. NoOfRows() function<\/span><\/h3>\n
This function is used to return the total number of rows in a table. <\/span><\/p>\n
The syntax of NoOfRows function in Qlik Sense<\/span>:<\/span><\/p>\n
NoOfRows(table_name)<\/pre>\n
Where table_name is the name of the table of which we want to know the number of rows. <\/span><\/p>\n
For example, if there is a table named \u2018Sales\u2019 and there are 80 rows in it. Then using this function, you can get this value is a result.<\/span><\/p>\n
Do you know about Qlik Sense Line Chart<\/a><\/strong><\/p>\n
LET x= NoOfRows(\u2018Sales\u2019);<\/pre>\n
Returns 80 as the value equal to x.<\/span><\/p>\n
v. NoOfTables() function<\/span><\/h3>\n
This function returns the total number of tables that are loaded in a LOAD statement. <\/span><\/p>\n
The syntax of NoOfTables Function<\/span>: <\/span><\/p>\n
NoOfTables()<\/pre>\n
Suppose you have loaded 10 different tables within a LOAD statement, then this function will return 10. <\/span><\/p>\n
vi. TableName() function<\/span><\/h3>\n
This function returns the name of the table corresponding to the unique number that the table has. <\/span><\/p>\n
The syntax of TableName Function in Qlik Sense<\/span>:<\/span><\/p>\n
TableName(table_number)<\/pre>\n
Where <\/span>table_number<\/span><\/i> is the n of the nth number of tables that has been loaded into a particular LOAD statement. <\/span><\/p>\n
vii. TableNumber() function<\/span><\/h3>\n
This function returns the number assigned to a specific table in a LOAD statement as a part of the script. In every LOAD statement, the tables are numbered, and the first table is numbered 0 and the second table 1 and so on.<\/span><\/p>\n
Let’s revise Qlik Sense Conditional Functions<\/a><\/strong><\/p>\n
The syntax of TableNumber Function<\/span>:<\/span><\/p>\n
TableNumber(table_name)<\/pre>\n
So, this was all in Qlik Sense Table Functions. Hope you like our explanation.<\/p>\n
3. Conclusion <\/span><\/h2>\n
Hence, we can use these Qlik Sense Table Functions in the data load script of Qlik Sense. Moreover, only NoOfRows function we can use as a chart function. Table functions are very useful when you want to manage all the tables loaded in your script by having all the information like total number of tables, table names, table numbers, number of rows etc.<\/span><\/p>\n
Still, if you have any query regarding Qlik Sense Table Functions, ask in the comment tab.<\/p>\n
See also –\u00a0<\/strong><\/p>\n
Qlik Sense Treemap Visualizations<\/a><\/strong><\/p>\n
Reference for Qlik Sense<\/a><\/strong>
1. Objective In our last tutorial, we discussed Qlik Sense Trigonometric and Hyperbolic functions. Today, we will see Qlik Sense Table Functions. Moreover, the table functions are used to apply certain operations on the...<\/p>\n","protected":false},"author":6,"featured_media":41836,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17408],"tags":[17626,17627],"class_list":["post-40564","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlik-sense-tutorials","tag-qlik-sense-table-functions","tag-table-functions-in-qlik-sense"],"yoast_head":"\nQlik Sense Table Functions With Syntax - DataFlair<\/title>\n<meta name=\"description\" content=\"Qlik Sense Table Functions,FieldName, FieldNumber,NoOfFields,NoOfRows,NoOfTables,TableName,TableNumber Table Functions in Qlik Sense\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qlik Sense Table Functions With Syntax - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Qlik Sense Table Functions,FieldName, FieldNumber,NoOfFields,NoOfRows,NoOfTables,TableName,TableNumber Table Functions in Qlik Sense\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-14T12:00:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Table-Functions-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qlik Sense Table Functions With Syntax - DataFlair","description":"Qlik Sense Table Functions,FieldName, FieldNumber,NoOfFields,NoOfRows,NoOfTables,TableName,TableNumber Table Functions in Qlik Sense","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/","og_locale":"en_US","og_type":"article","og_title":"Qlik Sense Table Functions With Syntax - DataFlair","og_description":"Qlik Sense Table Functions,FieldName, FieldNumber,NoOfFields,NoOfRows,NoOfTables,TableName,TableNumber Table Functions in Qlik Sense","og_url":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-14T12:00:01+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Table-Functions-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Qlik Sense Table Functions With Syntax","datePublished":"2018-11-14T12:00:01+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/"},"wordCount":959,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Table-Functions-01.jpg","keywords":["Qlik Sense Table Functions","Table Functions in Qlik Sense"],"articleSection":["Qlik Sense Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/","url":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/","name":"Qlik Sense Table Functions With Syntax - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Table-Functions-01.jpg","datePublished":"2018-11-14T12:00:01+00:00","description":"Qlik Sense Table Functions,FieldName, FieldNumber,NoOfFields,NoOfRows,NoOfTables,TableName,TableNumber Table Functions in Qlik Sense","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Table-Functions-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/11\/Qlik-Sense-Table-Functions-01.jpg","width":1200,"height":628,"caption":"Qlik Sense Table Functions With Syntax"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlik-sense-table-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Qlik Sense Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlik-sense-tutorials\/"},{"@type":"ListItem","position":3,"name":"Qlik Sense Table Functions With Syntax"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40564","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=40564"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40564\/revisions"}],"predecessor-version":[{"id":41837,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/40564\/revisions\/41837"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/41836"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=40564"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=40564"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=40564"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}