topic Re: hide dimension a pivot table in QlikView

hide dimension a pivot table

chrisg — Fri, 27 Jul 2012 08:06:30 GMT

Hello,

For articles, we have the following hierarchical data structure:

main group, category, article

Some customers do not use the Diminsion 'category'. Therefore, this is always the same value in the Diminsion category.

How is it possible to hide this dimension for customers who do not use them in a pivot table?

My goal is to deliver an application as a standard and not fit every application for the customer.

Many thx

Christoph

Re: hide dimension a pivot table

Fri, 27 Jul 2012 08:39:06 GMT

Hi Chris,

If you are using QV11then you can resolve this by checking the enable condition box in 'Settings for Selected dimension' dimension Tab of Pivot Table>>Properties. If you are going to reduce your application for different groups or if you are going to put access restriction for groups, then in the expression you can mention the group name and based on that you can choose to show or now show that dimension to the particular user or group.

PFA qvw file for reference.

Thanks,

Amey.