topic Re: Hide specific Columns in Pivot Table in QlikView

Columns in Pivot Table

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a Pivot Table. I need to show an hide few specific columns in the Pivot Table. How do I achieve this?

Here, under 2017, I need to show Sum(Value) and Sum(Sample) columns while under 2018, I need to show only Sum(Value) but not Sum(Sample). The entire column should be hidden, no nulls or '-'

Please refer to the sample data QVW file for better understanding. Really appreciate your help guys.

Re: Hide specific Columns in Pivot Table

Anil_Babu_Samineni — Wed, 17 Oct 2018 13:51:38 GMT

You added wrong file? Can you re attach for us

Re: Hide specific Columns in Pivot Table

qlikwiz123 — Wed, 17 Oct 2018 13:53:23 GMT

My bad. Corrected

Re: Hide specific Columns in Pivot Table

qlikwiz123 — Wed, 17 Oct 2018 14:06:31 GMT

Any help is really great in this issue

Re: Hide specific Columns in Pivot Table

qlikwiz123 — Wed, 17 Oct 2018 14:56:04 GMT

stalwar1‌ Any insight?

Re: Hide specific Columns in Pivot Table

sunny_talwar — Wed, 17 Oct 2018 15:03:13 GMT

Something like this?

Script changes

Input:

LOAD * INLINE [

Year, Value, Sample

2018, 2, 6

2018, 4, 4

2018, 6, 9

2017, 3, 3

2018, 4, 2

2017, 1, 5

2017, 3, 4

2018, 2, 1

2017, 8, 0

];

Dim:

LOAD * INLINE [

Dim

];

Dimensions

Year

=Pick(Dim, 'Value', 'Sample')

Expression

Pick(Dim, Sum(Value), If(Year = 2017, Sum(Sample)))

Re: Hide specific Columns in Pivot Table

qlikwiz123 — Wed, 17 Oct 2018 16:45:26 GMT

stalwar1‌ Thank you. You are a Genius