topic Re: Qlik Best Practices in Archived Groups

Qlik Best Practices

karthikeyan1504 — Tue, 22 Jul 2025 17:59:49 GMT

Hi All,

Most of the people feel that designing the data model in sql/oracle and qlik is pretty much same... but actually it has a lot of difference.

As everyone knows qlik engine works based on in-memory concept. Here are some basic best practices to keep in mind while developing the dashboard,

1. Joining two or more huge tables and linking the same does make a huge impact in system performance.

2. Avoid using the fields which is used for linking in UI expressions in charts.

3. Using apply map instead of joining tables improves the system performance.

4. Always use variables to refer the path of the file in load statement instead of absolute of directory path.

5. Drop fields & tables when it's not required for the final data model.

6. Follow the naming conventions such as 'Link_', '%key_' etc., for the linking fields, so that it can be hidden by using HidePrefix variable.

7. Avoid Syntetic keys & circular loop, as it will cause the inconsistency in the data model.

8. Use linked objects in UI wherever it's required such as primary filters, calendar objects.

9. Drop/ Comment all the unused fields in the final data model to reduce the load.

10. Try to accomplish most of the calculation via script unless it should be dynamic.

11. Use set analysis instead of if condition where ever it is possible in UI.

12. Though qlik can execute the SQL queries, it is always recommended to convert the script in qlik format to reduce the load and support the in-memory concept.

13. Always have a data in qvd where ever there is a possibility in reusing the data, so that the number of times we hit the actual data source will be reduced.

14. Follow the DAR principle in the dashboard design.

15. Use Exit Script command or execute the script in debug mode to find the issues and resolve it quickly by checking block by block.

Here I have attached the simple dashboard which explains the difference in the results when the link field and non-link field used in the same expressions.

Warm Regards,

Karthikeyan.

Re: Qlik Best Practices

manojkulkarni — Thu, 12 Nov 2015 10:36:06 GMT

Very useful document. Thanks for sharing

Re: Qlik Best Practices

NavinReddy — Thu, 12 Nov 2015 12:52:10 GMT

good one thanks for sharing

Re: Qlik Best Practices

Thu, 12 Nov 2015 16:42:28 GMT

Muito boa suas dicas, algumas delas me foram úteis. Obrigado.

Re: Qlik Best Practices

Fri, 13 Nov 2015 07:12:34 GMT

Excellent.. Tq..

Re: Qlik Best Practices

Fri, 13 Nov 2015 15:08:16 GMT

Good info. thanks!

Re: Qlik Best Practices

Tue, 17 Nov 2015 15:02:18 GMT

Thank you very much for this.

Regards!

Re: Qlik Best Practices

chrisg — Fri, 08 Jul 2016 15:30:26 GMT

Great piece of work, many thanks!

Re: Qlik Best Practices

joseph_morales — Fri, 15 Jul 2016 23:31:37 GMT

Thank you very useful document.

Regards!

Joseph

Re: Qlik Best Practices

Anonymous — Wed, 26 Oct 2016 10:26:10 GMT

Thanks for sharing!!!

~Sambhu

Re: Qlik Best Practices

Anonymous — Fri, 09 Dec 2016 07:59:08 GMT

thanks for sharing

Re: Qlik Best Practices

william_allen — Wed, 14 Dec 2016 14:39:58 GMT

Bookmarked, thanks

Re: Qlik Best Practices

v_petrenko — Mon, 09 Jan 2017 08:44:10 GMT

karthikeyan1504‌, thanks for sharing, nice list. Could you please remove all other categories except App Development, Scripting and Developer Toolkit for not confusing people and keeping Resource Library clean and well-structured.

Re: Qlik Best Practices

ahaahaaha — Mon, 09 Jan 2017 09:21:45 GMT

Very useful document. Thanks for sharing.

Re: Qlik Best Practices

Tue, 10 Jan 2017 08:40:39 GMT

Great help. Thanks alot for sharing.

Re: Qlik Best Practices

Lech_Miszkiewicz — Wed, 11 Jan 2017 03:15:54 GMT

Hi,

I have a question re 4. Always use variables to refer the path of the file in load statement instead of absolute of directory path.

I am just curious why not using Directory statement and relative paths? Why always variables? Once you use variable there, you are loosing functionality of coming back to wizard by clicking on "little hammer" icon from script editor.

regards

Lech

Re: Qlik Best Practices

Lech_Miszkiewicz — Wed, 11 Jan 2017 03:20:41 GMT

I also disagree with this:

(12. Though qlikview can execute the SQL queries, it is always recommended to convert the script in qlikview format to reduce the load and support the in-memory concept.),

especialy when you have to aggregate data (sum, max, count). This is in Qlik single threaded process and DB can deal with it much quicker, so SQL querry would return aggregated data much quicker than Qlik would perform Group by statement.

regards

Lech

Re: Qlik Best Practices

karthikeyan1504 — Wed, 11 Jan 2017 03:33:57 GMT

Hi Lech,

Thank you for your comments.

For 4th point, I have referred the below scenario,

Directory;

LOAD A,

FROM

[..\Data File\Mapping.xlsx]

(ooxml, no labels, table is Sheet1);

It's always good practice to have a complete path(It's better if we declare it in the variable to manage efficiently) instead of using the relative path which is shown above.

For 12th point, Yes I agree SQL can handle the aggregation better than qlikview. But consider the scenario where multiple dashboards are accessing the same data set from the SQL/Oracle database. It is always best practice to create the raw data qvd and do the aggregation on it rather than multiple dashboards hitting the database to get the same data set.

By following the approach mentioned above, we are reducing the load on database and using the qlik engine capability effieciently.

Hope this answers your query.

Thanks,

Karthikeyan.

Re: Qlik Best Practices

Lech_Miszkiewicz — Mon, 23 Jan 2017 00:15:32 GMT

Hi,

I agree that creating a QVD files/layers of RAW, Transformed qvd etc.. and reusing them for Qlik applications is a solution to go for.

However if there is an option where you can build views in SQL, for example to create keys, to aggregate data in SQL to lowest necessary granularity in DB then do it in SQL and use aggregated data as your source. You can still store and reuse them as a QVD files. The point is that you have think about whole picture and use common sense to decide which is the best way to go.

I would avoid saying "it is always recommended to convert the script in qlikview" as it is not always true.

Cheers

Lech

Re: Qlik Best Practices

luiskeyrus — Mon, 27 Mar 2017 10:50:13 GMT

i think the same. Thank You karthikeyan1504