Code Review Tools for Qlikview

[Anonymous]

Are there any code review tools for Qlikview?

[tresesco]

I am not aware of a tool for the same. May be, this helps you:

Script Best Practices:

•   Naming standards used for columns, tables, variables  
•   Script is well commented - changes date flagged  
•   First tab holds information section  
•   Subject areas each have tab in script  
•   Use of Include files or hidden script for all ODBC connections  
•   All code blocks with comment sections  
•   All file references using UNC naming  
•   Business names for UI fields  
•   Security script in Inlcude file  
•   Turn Generate Logfile option on  
•   UPPER() function used on Section Access fields  
•   Publisher Service Acct added to Section Access       
•   Use numeric flags where possible

Data Model Performance:

•    Synthetic keys removed from data model    
•    Ambiguous loops removed from data model    
•    Correct granularity of data    
•    Use of QVDs where possible    
•    Use integers to join tables where possible    
•    Remove system keys/timestamps from data model    
•    Unused fields removed from data model    
•    Remove link tables from very large data models    
•    Remove unneeded snowflaked tables (consolidate)    
•    Break concatenated dim. fields into distinct fields     
•    All QVD reads optimized    
•    Use Autonumber to replace large concatenated keys

[#3]

Good post Tresesco

Regards,

Lalit

[Anonymous]

Thank you tresesco

I am following most of these best practices in my report. But I need a code review tool for the same. When more than one person is working on a report, this type of tool will be helpful to check the integrity of the code developed by different developers.

Thanks,

Laxmi