Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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:
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
and what is the meaning of #
and what is the meaning of #
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
# is used as a prefix to name measures, fields that conatin amounts, for example:
[# Transported Passengers]
[# Departures Perfomesd]
[# Invoices Issued]
Hope this helps.