topic Re: Hide column in pivot table under a condition in QlikView

Hide column in pivot table under a condition

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I was wondering if it is possible to hide a column in a pivot table under a certain condition.

The problem im facing with this is that (See the attached pictures) I have a pivot table
with a 'Times Used column' and a Rank column.

When I expand the 'Times used column' you can see

the data that has been used that amount of times. But now the rank column changed to ranking the

data from the expanded field.
I want to make it so that when I expand the times used column, the rank column hides.

Thanks in Advance!

Re: Hide column in pivot table under a condition

sunny_talwar — Thu, 15 Dec 2016 13:54:19 GMT

May be you can make use of Dimensionality() function to do this.... would you be able to share a sample to help you with the exact thing?

Re: Hide column in pivot table under a condition

Thu, 15 Dec 2016 14:02:21 GMT

I dont think I can due to secrecy of the data im using, but I'll take a look at the Dimensionality() function

Re: Hide column in pivot table under a condition

sunny_talwar — Thu, 15 Dec 2016 14:23:08 GMT

I was looking at just an app with dummy data . I just don't have time to create a sample at my end

Re: Hide column in pivot table under a condition

Thu, 15 Dec 2016 14:26:06 GMT

I'll try to make a separate qvw with the same thing, but it'll take a bit of time

Re: Hide column in pivot table under a condition

danielact — Thu, 15 Dec 2016 14:28:24 GMT

I don't think there's a way to use a function that checks whether a dimension is expanded or not.

If the issue is the value on the rank function, you can put in some parameters so that instead of showing 1-4, it will show either 1 for all of them, or even increment them as 1, 2, 3, 4. Using a TOTAL can probably stretch the rank across all the dimensions as well.