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

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
Luminary Alumni
Luminary Alumni

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