Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what are the naming convection's
1) table name
2) qvd name
3) variable
4) flag
5) ipc nameing
one more that
5) Reduce columns: find unused fields in that data model use documnetanalyzer.qvw against your app to do this , and then copy the drop fields statements that are genrated for the unused fields and place these into a new tab in appllication , as the last tab in the script.
Do want the naming convention in qlikview
yeah i have doubt that what should i keep
table name
qvd name any standards are there
please help out sujeet , please help me in this condtion major one
what should i keep table name ( i mean only capital letters , or capital and small letters)
Hope it helps
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='_' ;