topic Re: Hiding expression column in Pivot table in QlikView

Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 06:57:14 GMT

Hi,

Can anyone help in hiding expression column in pivot table. I have a pivot where I would like to hide expression columns and I tried in many ways but unable to resolve it.

Re: Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 07:00:34 GMT

Did you try by using the conditional option for expressio?

Re: Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 07:09:47 GMT

Yes Greeshma, I entered 0, False()....You have any idea of these...

Re: Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 07:21:06 GMT

Try 1=0

Re: Hiding expression column in Pivot table

anbu1984 — Thu, 28 May 2015 07:22:53 GMT

Using 0 or False() in condition will hide the expr. Didn't that work for you?

Re: Hiding expression column in Pivot table

prajapatiamar38 — Thu, 28 May 2015 07:48:54 GMT

Hi...

For hiding the expression column simply write False() in conditional.It will hide that expression column.

Re: Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 07:57:35 GMT

HI Amarnath,

Records are missed in table with condition False(). Any other solution please?

Re: Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 08:01:54 GMT

Entering 0 should hide it. Can you share your QVW or some screenshot?

Re: Hiding expression column in Pivot table

avinashelite — Thu, 28 May 2015 08:04:42 GMT

share your app. will check on this

Re: Hiding expression column in Pivot table

prajapatiamar38 — Thu, 28 May 2015 08:07:04 GMT

Can you share your qvw.

Re: Hiding expression column in Pivot table

kamielrajaram — Thu, 28 May 2015 08:11:58 GMT

Hi Shiva,

Have you tried creating a variable and setting it to 0 and in the condition of the expression type in vVariable = 1.

Kamiel

Re: Hiding expression column in Pivot table

buzzy996 — Thu, 28 May 2015 08:14:15 GMT

hope tis will works for u!

Re: Hiding expression column in Pivot table

Anonymous — Thu, 28 May 2015 08:14:44 GMT

Thanks all for your responses.

We can not hide column in Pivot table. So I changed chart from Pivot to Straight to hide expression column. It is fine and working.

Re: Hiding expression column in Pivot table

buzzy996 — Thu, 28 May 2015 08:16:19 GMT

hi,the below example shared by me with pivot table,are u tried that?

Re: Hiding expression column in Pivot table

Thu, 28 May 2015 08:23:39 GMT

check the checkbox conditional and wrire condition 1>2

it will hide the expression column.