{"id":38528,"date":"2018-11-18T17:00:15","date_gmt":"2018-11-18T11:30:15","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38528"},"modified":"2021-12-07T11:20:09","modified_gmt":"2021-12-07T05:50:09","slug":"qlikview-dollar-sign-expansion","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/","title":{"rendered":"Dollar Sign Expansion in QlikView (Latest) – Complete Guide"},"content":{"rendered":"

In QlikView scripting<\/strong>, there are many features that make creating a script comparatively convenient. One such feature is QlikView Dollar sign expansions. <\/span><\/span><\/p>\n

This tutorial dedicatedly discusses what are dollar sign expansions in QlikView and what are they used for in QlikView. Moreover, we will learn how to use dollar sign expansions to expand variables, parameters and expressions<\/span><\/span><\/p>\n

So, let’s start exploring Dollar Sign Expression in QlikView.<\/p>\n

What is Dollar Sign Expansion in QlikView?<\/h3>\n

QlikView Dollar sign expansion is a method of expanding or replacing values (string or numbers) in a script.<\/p>\n

We first define a variable, parameter or an expression in the script and then use dollar-signs to create a container like which defines what intends to fill this space.<\/p>\n

During script execution, the variable, expression, the parameter having a dollar sign is read and replace by the intended or actual value (relevant to the data).<\/p>\n

The values written as dollar-signs follow a syntax,<\/p>\n

$(variable|expression|parameter)<\/p>\n

Let us understand it better through an example. Say we have a line of command from the script.<\/p>\n

If(Year=$(=Year(Today())), LightGreen())<\/p>\n

Here, the QlikView dollar sign expression or function is\u00a0Year(Today())\u00a0which will evaluate during script execution and this value will replace by the resultant value of the evaluation.<\/p>\n

If the year in today\u2019s date is 2018, then Year(Today())\u00a0\u00a0will replace by 2018. The expression after the dollar sign expression gets evaluate will be,<\/p>\n

If(Year=2018, LightGreen())<\/p>\n

This replacing of values represents\u00a0by a dollar sign are said to expand. The term expansion does not mean expanding a value in size, but it means revealing or unfolding the actual value which is to fill in place of the dollar-signed value.<\/p>\n

Hence, the name Dollar sign expansion in QliKview, as the expansion is done using the dollar-signs as indicators pointing towards the values that need to expand.<\/p>\n

QlikView Dollar sign expansion can contain or can use with a variable, parameter or expression. In the following sections, we will understand each type in detail.<\/p>\n

Dollar Sign Expansion Using a Variable<\/h3>\n

Variables are expanded to the values they suppose to contain when evaluate. The QlikView dollar-sign expansion which is done on variables use syntax as given below,<\/span><\/span><\/p>\n

    \n
  • For text variables<\/span><\/span><\/li>\n<\/ul>\n

    $(<\/span><\/span>variablename<\/span><\/span><\/span>)<\/span><\/span> \u00a0\u00a0\u00a0\u00a0<\/span><\/span><\/strong><\/p>\n

      \n
    • For numeric variables expansion<\/span><\/span><\/li>\n<\/ul>\n

      $(#<\/span><\/span>variablename<\/span><\/span><\/span>)<\/span><\/span> \u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/span><\/strong><\/p>\n

      In case of text variables if the variablename does not equate to any value then an empty string returns. Similarly, in the case of numeric variables, if variablename not assign to a value then 0 returns. <\/span><\/span><\/p>\n

      Let us understand how variables are expanded with QlikView dollar sign expansion method. <\/span><\/span><\/p>\n

      Example 1<\/b><\/span><\/span><\/span><\/span><\/p>\n

      SET DecimalSep=’,’;<\/span><\/span><\/span><\/span><\/span><\/p>\n

      LET X = 9\/2;<\/span><\/span><\/span><\/span><\/span><\/p>\n

      Dollar-sign expansion\u00a0<\/span><\/span>$(X)<\/b><\/span><\/span>\u00a0will expand to\u00a04,5 (because it gives string values), while\u00a0<\/span><\/span>$(#X)<\/b><\/span><\/span>\u00a0will expand to\u00a04.5 (as numeric values are given as a result).<\/span><\/span><\/span><\/span><\/p>\n

      Example 2<\/b><\/span><\/span><\/span><\/span><\/p>\n

      Set Mypath=C:\\MyDocs\\Files\\;<\/span><\/span><\/span><\/span><\/span><\/p>\n

      …<\/span><\/span><\/span><\/span><\/span><\/p>\n

      LOAD * from $(MyPath)abc.csv;<\/span><\/span><\/span><\/span><\/span><\/p>\n

      Data will be loaded from\u00a0<\/span><\/span>C:\\MyDocs\\Files\\abc.csv<\/i><\/span><\/span>.<\/span><\/span><\/span><\/span><\/p>\n

      Example 3<\/b><\/span><\/span><\/span><\/span><\/p>\n

      Set CurrentYear=2015;<\/span><\/span><\/span><\/span><\/span><\/p>\n

      …<\/span><\/span><\/span><\/span><\/span><\/p>\n

      SQL SELECT * FROM table1 WHERE Year=$(CurrentYear);<\/span><\/span><\/span><\/span><\/span><\/p>\n

      Rows with\u00a0Year=2015\u00a0will be selected.<\/span><\/span><\/span><\/span><\/p>\n

      Dollar Sign Expansion Using Parameters<\/h3>\n

      Parameters can be set using the dollar sign expansion in QlikView. The parameters must define as $1 $2 $3, as many you like.<\/span><\/span><\/p>\n

      The values expanding as these parameters must have a comma and separate only be as much in number as defined in the dollar-sign expression. <\/span><\/span><\/p>\n

      Whether you want the parameters to treat as a string or as numeric values is decided by keywords Set (for strings) and Let (for numbers).<\/span><\/span><\/p>\n

      Example<\/b><\/span><\/span><\/p>\n

      Set SUM=\u2019$1+$2+$3\u2019;<\/span><\/p>\n

      Set X=$(SUM(2,4,6));<\/span> \/\/ will return a string \u20182+4+6\u2019 as the value of X<\/span><\/span><\/p>\n

      Set SUM=\u2019$1+$2+$3\u2019;<\/span><\/p>\n

      Let X=$(SUM(2,4,6));<\/span> \/\/ will return the sum of three values 12 in X<\/span><\/span><\/p>\n

      Now for instance, if we define a variable SUM with some parameters,<\/span><\/span><\/p>\n

      Set SUM=\u2019$1+$2+$3\u2019;<\/span> \/\/ known as formal parameter<\/span><\/span><\/p>\n

      Set X=$(SUM(2,4,6));<\/span> \/\/ known as actual parameter<\/span><\/span><\/p>\n

      Here both the numbers of formal ($1, $2, $3) and actual (2,4,6) parameters are equal hence making it an ideal situation. <\/span><\/span><\/p>\n

      But, however, if the formal and actual parameters are not equal and one exceeds the other, only the values in the actual parameter that corresponds of values in the formal parameter will use, ignoring others.<\/span><\/span><\/p>\n

      Hence, it is important to follow what define in the formal parameter.<\/span><\/span><\/p>\n

      Pay attention to the example cases given below explaining the point made about formal parameters. <\/span><\/span><\/p>\n

      Example:\u00a0\u00a0<\/b><\/span><\/span><\/span><\/p>\n

      Set MUL=\u2019$1*$2\u2019;<\/span><\/p>\n

      Set X=$(MUL);<\/span> \/\/<\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>returns ‘$1*$2’ in\u00a0X<\/span><\/span><\/span><\/p>\n

      Set X=$(MUL(12));<\/span> \/\/<\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>returns ’12*$2′ in\u00a0X<\/span><\/span><\/span><\/p>\n

      Let X=$(MUL(5,7,9));<\/span> \/\/<\/span><\/span><\/span>\u00a0<\/span><\/span><\/span>returns\u00a035\u00a0in\u00a0X, ignoring the third value 9 <\/span><\/span><\/span><\/p>\n

      because it exceeds the formal parameter value <\/span><\/span><\/span><\/p>\n

      limit.<\/span><\/span><\/span><\/p>\n

      Dollar Sign Expansion Using an Expression<\/h3>\n

      Expressions of a script can also expand using the dollar sign expansion in QlikView. The syntax for expressions is,<\/span><\/span><\/p>\n

      $(=expression )<\/span><\/span><\/span><\/strong><\/p>\n

      The expression will evaluate and return a value which the expression will replace by. For example,<\/span><\/span><\/p>\n

      $(=Year(Today()));<\/span> \/\/ returns a string with the current year i.e. 2018.<\/span><\/span><\/strong><\/p>\n

      $(=Only(Year)-1);<\/span> \/\/ returns the year before the selected one i.e. 2017.<\/span><\/span><\/strong><\/p>\n

      File Inclusion Using Dollar Sign Expansion<\/h3>\n

      Files from the system i.e. external files can also include in the script using dollar sign expansion in QlikView. In this case, the file name will expand to the file contents. <\/span><\/span><\/p>\n

      This option is of great use when you want to store script or part of a script as a text file, you can do it using dollar sign expansion so that the script file expands to the original script commands during script execution.<\/span><\/span><\/p>\n

      The syntax used for file inclusion is,<\/span><\/span><\/p>\n

      $(include=filename)<\/span><\/span><\/span><\/strong><\/p>\n

      Example:\u00a0\u00a0<\/b><\/span><\/span><\/span><\/p>\n

      $(include=C:\\Documents\\MyScript.qvs);<\/span><\/span><\/p>\n

      So, this was all about QlikView Dollar Sign Expansion Tutorial. Hope you like our explanation.<\/p>\n

      Conclusion<\/h3>\n

      Hence, we discussed what is dollar sign expansion in QlikView, then we understood the ways in which dollar sign expansions can use. <\/span><\/span><\/p>\n

      We saw how to use dollar sign expansions to expand variables, parameters and expressions. We hope this tutorial was helpful.<\/span><\/span><\/p>\n

      In case of any queries, drop it in the comment box below, we will be happy to help.<\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

      In QlikView scripting, there are many features that make creating a script comparatively convenient. One such feature is QlikView Dollar sign expansions. This tutorial dedicatedly discusses what are dollar sign expansions in QlikView and...<\/p>\n","protected":false},"author":6,"featured_media":38534,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[17268,17265,17267,17266],"class_list":["post-38528","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-sign-expansions","tag-dollar-sign-expansions","tag-dollar-sign-expansions-in-qlikview","tag-qlikview-dollar-sign-expansions"],"yoast_head":"\nDollar Sign Expansion in QlikView (Latest) - Complete Guide - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Dollar Sign Expansion Tutorial - How to Use Dollar sign Expressions to Expand- Variables, parameters, expressions, File Inclusion Using Dollar Sign\" \/>\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\/qlikview-dollar-sign-expansion\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Dollar Sign Expansion in QlikView (Latest) - Complete Guide - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Dollar Sign Expansion Tutorial - How to Use Dollar sign Expressions to Expand- Variables, parameters, expressions, File Inclusion Using Dollar Sign\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/\" \/>\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-18T11:30:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:50:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dollar-Sign-Expansion-Expands-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":"Dollar Sign Expansion in QlikView (Latest) - Complete Guide - DataFlair","description":"QlikView Dollar Sign Expansion Tutorial - How to Use Dollar sign Expressions to Expand- Variables, parameters, expressions, File Inclusion Using Dollar Sign","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\/qlikview-dollar-sign-expansion\/","og_locale":"en_US","og_type":"article","og_title":"Dollar Sign Expansion in QlikView (Latest) - Complete Guide - DataFlair","og_description":"QlikView Dollar Sign Expansion Tutorial - How to Use Dollar sign Expressions to Expand- Variables, parameters, expressions, File Inclusion Using Dollar Sign","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-11-18T11:30:15+00:00","article_modified_time":"2021-12-07T05:50:09+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dollar-Sign-Expansion-Expands-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\/qlikview-dollar-sign-expansion\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Dollar Sign Expansion in QlikView (Latest) – Complete Guide","datePublished":"2018-11-18T11:30:15+00:00","dateModified":"2021-12-07T05:50:09+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/"},"wordCount":974,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dollar-Sign-Expansion-Expands-01.jpg","keywords":["$ sign Expansions","Dollar Sign Expansions","Dollar Sign Expansions in QlikView","QlikView Dollar Sign Expansions"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/","name":"Dollar Sign Expansion in QlikView (Latest) - Complete Guide - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dollar-Sign-Expansion-Expands-01.jpg","datePublished":"2018-11-18T11:30:15+00:00","dateModified":"2021-12-07T05:50:09+00:00","description":"QlikView Dollar Sign Expansion Tutorial - How to Use Dollar sign Expressions to Expand- Variables, parameters, expressions, File Inclusion Using Dollar Sign","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dollar-Sign-Expansion-Expands-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/10\/Dollar-Sign-Expansion-Expands-01.jpg","width":1200,"height":628,"caption":"Dollar Sign Expansion in QlikView (Latest) - Complete Guide"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-dollar-sign-expansion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"Dollar Sign Expansion in QlikView (Latest) – Complete Guide"}]},{"@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\/38528","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=38528"}],"version-history":[{"count":6,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38528\/revisions"}],"predecessor-version":[{"id":96504,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/38528\/revisions\/96504"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/38534"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=38528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=38528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=38528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}