topic Re: How to hide column in pivot table? in QlikView

How to hide column in pivot table?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

How to hide column in pivot table. please provide me any script or screen short

sunny_talwar — Thu, 16 Jun 2016 10:16:54 GMT

Can you elaborate on what exactly are you trying to do?

Anonymous — Thu, 16 Jun 2016 10:22:03 GMT

Hi you could try reading this useful document. Hope it helps you.

Kindest Regards

Brian

sumeet-vaidya — Thu, 16 Jun 2016 10:22:20 GMT

Hi,

Tick the Enable Condition option (For Dimension) and Condition option (For Expression).

Kindly provide a condition which returns a false value (For E.g. 1=2)

Regards

Sumeet

nizamsha — Thu, 16 Jun 2016 10:26:08 GMT

u can hide in straight table weather measure or dimension ->under presentation tab hide column

for some sorting u want to hide in pivort table go to dimension and change the background color and text color as white

if its not elaborate ur scenario

Thu, 16 Jun 2016 10:27:13 GMT

i have one pivot table in pivot table has 7 columns so i want delete or hide one column in 7 columns.

example :

count(values) column i want delete or hide. in pivot table

no name address phno city town count(value) (i want hide this column)

here i am not take count(value) (expressions) data is not showing. with count(value) column in pivot table data is showing

out put

no name address phno city town

Thu, 16 Jun 2016 10:29:07 GMT

thank you sir i got it

nizamsha — Thu, 16 Jun 2016 10:42:57 GMT

in Expression Tab u have condtional option in that write some variable like this

Check the conditional box and write the variable vButton='B1'

it will hide the count(value) column .once u got what you want mark the thread as helpful or correct

nizamsha — Thu, 16 Jun 2016 10:44:01 GMT

PFA