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: 
swarup_malli
Specialist
Specialist

Best practices for the administrator of Qlikview server?

Hi,

  I'm rookie when it comes to administering  qlikview server.

  Currently I'm working with Qlikview 11 enterprice edition.

  What are the best practises a administrator should follow ?

Thanks

MS

6 Replies
swarup_malli
Specialist
Specialist
Author

Some of the best practices, I know and would like to share with fellow QVS administrators are :.

  • 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
  • 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 rows in export ie if a table has 60 million rows and users exports them..ie 60 million not good, limit it to 1000 or something.
  • 10)   The share collaboration feature eats 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)   When you delete a qvw delete all tasks associated with it and free all the document cals associated with it.
  • 13)   QVS detector
  • 14)   QVPT
  • 15)   In qvs 11 you can do extraction from the server itself, meaning you don’t have to create a separate extraction qvw .
Miguel_Angel_Baeyens

Hi,

Although some of them are best practices for developers, I shouldn't agree with many of the points you list above, depending on what the user is expecting from the tool.

Downloading is not a best practice. Ot because bandwidth, but mainly because the cost and time of installing and configuring QlikView Desktop in each computer.

Sharing objects will use a small amount of disk and memory, but it can provide users with a powerful tool to build their own analyses.

It's always best practice to have QVW to control what you extract and create tasks from those files.

Source/User documents is used by Publisher, it distributes if you set up a task to do so.

If you have a chart displaying 60 million rows, I'd say that something is wrong in the model or analysis (I mean, you really need 60 million rows in one chart? There is no way to analyze that!)

Etc...

I'd recommend you to go to the QlikView site, training, and follow the several free documents and videos you have.

Hope that makes sense.

Miguel

swarup_malli
Specialist
Specialist
Author

Thank you Miguel, The points were very helpful

gainkarthi
Partner - Specialist
Partner - Specialist

Miguel,

Do we have any document for this?.

Regards,

Karthi

Anonymous
Not applicable

... and don't forget the 3 B's :

          Backup, Backup & Backup.

dmohanty
Partner - Specialist
Partner - Specialist

Do we have any Best Practice Document for QlikView Server Management?

Any PDF or PPT?