Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

please help me out its bit urgent

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.

4 Replies
sujeetsingh
Master III
Master III

Do want the naming convention in qlikview

Not applicable
Author

yeah  i have  doubt that  what  should i keep

  table  name  

   qvd name   any standards  are there

Not applicable
Author

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)

sujeetsingh
Master III
Master III

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='_' ;