Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

please help me out its bit urgent required

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  generated for the unused fields and place these  into  a new tab in application  , as the last tab in the script.

2 Replies
sujeetsingh
Honored Contributor III

Re: please help me out its bit urgent required

May it help you

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

pover
Honored Contributor

Re: please help me out its bit urgent required

I'm not sure what the question about the documentanalyzer is, but it is better to never load unused fields instead of dropping them at the end of the script.  You'll save time and RAM. (Qlikview Notes: DROP FIELD Does Not Release All Space)

Karl

Community Browser