Cleanup Document Info Categories - Qlik Community

bhelms · ‎2013-01-08

We are re-working a lot of of our administration activities for QlikView and in the process are re-naming quite a few of the categories that get listed on the accesspoint. When setting up the task in the QEMC, QlikView auto populates a list of the most popular categories used. The problem is, this list is getting increddibly long, and most of them are no longer used. Is there any way to clean this up? I searched around but couldn't find anything related to this.

Thanks for the help.

Bill_Britt · ‎2013-01-09

The only way I know to do this is to edit the Category.xml file that is located at "C:\ProgramData\QlikTech\ManagementService\QVPR".

NOTE: If you do this make a backup first.

Stop all the QlikView services:

In the Category.xml file at the bottom you will see the Category names.

So, if I wanted to clear test2 I would delete the line below.

<Category Name="test2" ID="d5187273-7fe0-4a9d-84a4-cadbbddaed4c" ModifiedByUser="QV-11-SERVER\Administrator" ModifiedTime="2013-01-09T17:42:03.2367175-05:00" />2

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.

Report Inappropriate Content · ‎2013-02-04

Thanks Bill. I had the similar problem and I fixed it by modifying the Category.xml file in C:\Documents and Settings\All Users\Application Data\QlikTech\ManagementService\QVPR. I am using Windows server 2003 R2 and using Qlikiew Server without Publisher in our test environment. The following is what I did,

1. Find the the Category.xml file in the folder mentioned above and make a backup copy.

2. Open the XML file using Notepad deleted the lines including <Category Name=" xxxx", xxxx is the category to be deleted

3. Save the modified XML file

4. Restart "Qlikview Management Service"

Regards.

David