Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

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
Master
Master

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

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 (;)

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
Specialist III
Specialist III
Author

and what is the meaning of #

agni_gold
Specialist III
Specialist III
Author

and what is the meaning of #

Not applicable

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
Specialist II
Specialist II

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

[# Transported Passengers]

[# Departures Perfomesd]

[# Invoices Issued]

Hope this helps.