topic Re: How to delete Category in Qlikview in QlikView

How to delete Category in Qlikview

Mon, 26 Jan 2026 18:19:17 GMT

Hi All, When we create publisher task or directly in user documents we have option to create Categories. Iwant to know where i can delete a particular category.

THanks for your help in Advance.

Re: How to delete Category in Qlikview

Ricardo_Gerhard — Mon, 08 Jul 2013 19:35:37 GMT

C:\ProgramData\QlikTech\ManagementService\QVPR\Category.xml

Re: How to delete Category in Qlikview

Tue, 09 Jul 2013 14:09:14 GMT

so after deleting that not required entry fro mxml file , i restarted management services and it worked fine as expected..

Thanks

Re: How to delete Category in Qlikview

Tue, 09 Jul 2013 14:09:49 GMT

do we have a way to find list of users assigned to a publisher task like this?

Re: How to delete Category in Qlikview

Bill_Britt — Tue, 09 Jul 2013 16:52:55 GMT

Yes, You can look at the DistributionDetail.xml. However, you have to look at DocumentTask.xml to find the document ID.

Bill

Re: How to delete Category in Qlikview

Mon, 11 May 2015 16:53:05 GMT

Hi Ricardo,

I made changes to the category.xml file. But after the services got restarted the Task tab (under Status) doesn't show any of my tasks. It displays "No Tasks Scheduled".

Can you let me know why that's happening?

Regards,

Janaki

Re: How to delete Category in Qlikview

Ricardo_Gerhard — Mon, 11 May 2015 17:00:27 GMT

Hi Lynda,

Restore the old DistributionDetail.xml and Category.xml and restart services to your tasks restored.

After, change all tasks to one category that will not be removed.

Stop service and remove again it wrong category and will works.

Regards,

Ricardo Gerhard

Re: How to delete Category in Qlikview

Mon, 11 May 2015 17:16:32 GMT

Hi Ricardo,

What is the use of DistributionDetail.xml? I made changes only to the Category.xml and took backup for that. Don't have backup for DistributionDetail.xml file.

Re: How to delete Category in Qlikview

Bill_Britt — Mon, 11 May 2015 17:50:07 GMT

Hi,

So you don't have a folder named Backup in the QVPR directory?

Bill

Re: How to delete Category in Qlikview

Mon, 11 May 2015 18:32:06 GMT

Thanks Bill. I see the files.

Just to summarize what I need to do.

Stop the QlikView Management Service
Updated the Category.xml and DistributionDetail.xml file.
Restart the service

But if I revert back the Category.xml I would get back the unwanted categories which I removed. How to resolve this issue.

Regards,

Janaki

Re: How to delete Category in Qlikview

Bill_Britt — Mon, 11 May 2015 19:16:26 GMT

Hi,

The best tool to do this is the XMLDBViewer that is part of the powertools. You just click on the line and delete it.

Bill

Re: How to delete Category in Qlikview

Mon, 11 May 2015 20:28:12 GMT

Hi Bill,

Thanks for the XMLDBViewer tool.

Can you let me know how to remove the unwanted category without affecting the Task list?

Regards,

Janaki

Re: How to delete Category in Qlikview

Bill_Britt — Tue, 12 May 2015 11:18:25 GMT

Remove it from the Category XML file and then rerun the task.

Bill

Re: How to delete Category in Qlikview

Tue, 12 May 2015 16:14:04 GMT

Hi Bill,

I removed the required task from category.xml file. But since I had not stopped the services the first time I did it, now the QMC is show this error. All the tasks that were displayed earlier are now not shown. They are running on time but just not visible.

As per our discussion yesterday I stopped the services, reloaded the old category.xml and distributiondetail.xml files and restart the services. But still getting the same issue.

Please let me know if you have any solution for this.

Appreciate the help.

Regards,

Janaki

Re: How to delete Category in Qlikview

Bill_Britt — Tue, 12 May 2015 17:18:37 GMT

Hi,

I would again replace the two files and just leave the Category that you have added in there. Just don't select it.

Bill

Re: How to delete Category in Qlikview

paputzback — Mon, 10 Aug 2015 21:42:38 GMT

To be clear, you are saying there is no safe way to remove a category now. And since we can't clean up orphaned categories, we just need ignore it in the list.

Re: How to delete Category in Qlikview

Bill_Britt — Tue, 11 Aug 2015 11:49:44 GMT

Hi Phillip,

You can clean them up, but like any file change there are risks. So, make sure you have a backup of the files you modify.

Bill

Re: How to delete Category in Qlikview

paputzback — Wed, 12 Aug 2015 13:33:43 GMT

Do you have an order in how to accomplish this with the best chance of results?

Do we just need to delete it from the categories.xml file or do we need to track the unused ID back through all the related XML files and delete them? I tired using that XMLDBViewer and while it works great for viewing one table, I can't find any documentation on how to use the relationship tab or do add joins in the query designer. I tried T-SQL since that is what I know, but it errors off.

Re: How to delete Category in Qlikview

BuTbka — Wed, 17 Jan 2024 08:45:43 GMT

We just solved that case successfully.
We use MS SQL for QVPR(for file option it is almost the same)
- Find your category in the Category table(file)
- Copy category ID
- Search that ID in TaskCategory table(file) in CategoryID field
- If something found then you should change category for that task(s) (you can find task name by TaskID field in DocumentTask table(file) - filed ID)
- If not you can delete record(s)
- Restart QMC service