Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Best Practices Question in Qlikview

For interview purposes, how should this question be answered. My understanding about best practice is that the overall performance should be maximized by optimizing the data model. That is by perfecting the data model not just in form but in function too. Form as in the fact table should be at the center linked with dimension tables surrounded by it (if it is a star schema). Function as in: it should be free from synthetic keys, avoid circular reference by using foreign keys, use joins wherever applicable, applymaps are even better, use resident load..   precalculate values to save processing times, Apply incremental load, use QVD data format ...the list goes on. So all these actions lead to making the performance of Qlikview efficient and reducing the consumption of resources. And this is what i gather about Qlikview best practices. So best practices is all about performance and efficiency or is there some thing else. Please comment/correct/advice on my take.

Many Thanks.

4 Replies
Not applicable
Author

I think u have covered end to end  ,pls go ahead

simondachstr
Luminary Alumni
Luminary Alumni

best practice

noun

  1. commercial or professional procedures that are accepted or prescribed as being correct or most effective

    Source: Google.com

Not applicable
Author

I personally would respond with a question, "what type of best practices do you mean?"  Scripting? Visuals? Performance? Architecture? All of the above?

Scripting can be as simple as using naming conventions

Do's and Don'ts of visuals, architecture, expressions etc...

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, John.

I think Felim makes a good point. I am involved in drafting best practices which include not just optimisation and architecture but also visual consistency between tabs and applications, no massive company logos occupying primary real estate on the dashboard and version control within the script.

Regards,

Neil