Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

agni_gold
Valued Contributor II

Naming Convention followed in Load Script

Please tell me what are the naming convention in load script :

As  %,# an many special charecters are used in load script what are these meaning and how can i use please tell me in detail.

6 Replies
Sokkorn
Honored Contributor

Re: Naming Convention followed in Load Script

Hi,

This is just an prefix for a field and we can define at our own way. Here is some common use in script:

Variables   Starts with a "v"     e.g.    vCurrentYear
Key Fields   Starts with a "%"     e.g.    %CustomerKey
Flag Fields   Starts with a "_"     e.g.    _YTDFlag
Cycle Group   Starts with a "<"     e.g.    <ProductCycle
Drilldown Group   Starts with a ">"     e.g.    >GeoDrillDown

Key Field Separator    Separated by "_"    e.g.    Company&'_'&Nbr as Key

Temp Fileds/Tables    End With "_tmp"   e.g.    Daily_Trans_tmp

By the way, is use those prefix to hide a field while we load data. Something like Set HidePrefix='_' ;

Regards,

Sokkorn

Not applicable

Re: Naming Convention followed in Load Script

Hi,

QlikView is very flexible in the naming conventions you can use to keep the script maintainable within an organization. See for example the response of Sokkorn on what pre- and postfixes you can agree upon within your organization.

There are some special characters to take into account. The most important are:

  • // indicates a comment line
  • /* A LOT OF TEXT */  indicates multiple lines of comment between the slashes
  • $ indicates a variable is to be used

In the script you will see change the color if something special is taking place. For example blue indicates a function, gray is a variable and green is comment by default. And all commands are ended by a semicolon (Smiley Wink

If you need more details I suggest to check the help file for qlikview, follow some training and/or google for it as there is much already available (and in detail).

Kind regards,

Matthijs

agni_gold
Valued Contributor II

Re: Naming Convention followed in Load Script

and what is the meaning of #

agni_gold
Valued Contributor II

Re: Naming Convention followed in Load Script

and what is the meaning of #

Not applicable

Re: Naming Convention followed in Load Script

As far as I know this character has no special meaning. It is sometimes used in functions like num# and date# which actually tell QlikView how to transform the value between brackets into a number or date. In comparison the version without # (num and date) only tell QlikView how to display the number or date.

You can use the # also as (part of a) field name.

Kind regards,

Matthijs

salto
Valued Contributor II

Re: Naming Convention followed in Load Script

# is used as a prefix to name measures, fields that conatin amounts, for example:

[# Transported Passengers]

[# Departures Perfomesd]

[# Invoices Issued]

Hope this helps.

Community Browser