Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
Specialist
Specialist

Best practices for the administrator of Qlikview server

Some of the best practices, I employ as an admin  and would like to share it with the hope that others might benefit from it :

1) Never copy  qvw into root folder cos it contains  pgo files ,they are like configuration  files.

2) Everything on mounted folder.

3) Always create task groups, this will avoid confusion when you have huge number of tasks.

1)       Jobs/Tasks setup via the QEMC are organized and structured as followed:

<Task Usage> : <QVW Name> - <Task Type> - <Subject Area>

Example for a Presentation qvw: 

Access Point:  Maintenance App – Reload - Maintenance

Example for a Transform qvw: 

QVD Transform:  Complaint – Reload

Example for an Extract qvw: 

QVD Extract: Avenue - Reload



6) Minimize the use of input fields.

7) Not a good practice to let the users add objects via access point ,uses up memory.

😎 Not a good practice to let users download documents ( bandwidth usage)

9) Limit the number of records to be displayed in the table  i.e. if a table has 100k rows  then

     limit it to 1000 or something.  

10) The share collaboration feature eats up  resources.

11) Put all the source qvd, include files and images in source document, maintain 1 source for 1 qvw and 

place qvw on the user document.

12)  Before you delete a qvw,first delete all tasks associated with it and free all the document cals

associated  with the document,else you end up losing document cals.

13) QVS detector

14) QVPT

15) Latest  feature of QVS 11 enterprice edition is you no longer need to employ a qvw for extraction of

      qvds,server can perform this task.



3 Replies
Anonymous
Not applicable

How do you implement #9 (limiting the # of export rows)?

swarup_malli
Specialist
Specialist
Author

Hey fchukokie,

I apologize ,that was a mistake from my side, I don't think we can place a limit on export of rows.

But we can disable the option to export before deploying it .

I've amended the above document now. Thank you for highlighting it.

Swarup

Anonymous
Not applicable

Understood...I didn't think that we could either, but was hopeful that I was wrong

Thanks!

-Frank