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: 
Anonymous
Not applicable

Code Review Tools for Qlikview

Are there any code review tools for Qlikview?

3 Replies
tresesco
MVP
MVP

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
Not applicable
Author

Good post Tresesco

Regards,

Lalit

Anonymous
Not applicable
Author

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