topic Re: Hide expression column from pivot chart in QlikView

Hide expression column from pivot chart

Mon, 27 Aug 2012 10:46:14 GMT

As attached below, i have a pivot table where at the end there is an expression column for the total.

how can i hide that

Re: Hide expression column from pivot chart

jagannalla — Mon, 27 Aug 2012 10:56:02 GMT

If you are using qvw 11 version, there is Conditional option in Expression Tab just give =False()

Re: Hide expression column from pivot chart

Tue, 28 Aug 2012 04:58:46 GMT

I have version 11 .I tried this but the whole table dissappeared.

Any other solution???

Re: Hide expression column from pivot chart

jagannalla — Tue, 28 Aug 2012 09:43:27 GMT

I think you have only single expression. If that is the case, hide the expression as i saild. Now go to Presentation Tab and uncheck "Suppress Zero-Values".

Hope it helps you

Cheers!

Jagan

Re: Hide expression column from pivot chart

Tue, 28 Aug 2012 09:53:29 GMT

Thank you that works

Re: Hide expression column from pivot chart

jagannalla — Tue, 28 Aug 2012 10:00:48 GMT

Bilalelabd,

That's well. Please mark as correct answer, it helps others to search easily.

Re: Hide expression column from pivot chart

Tue, 28 Aug 2012 10:03:33 GMT

Alright sorry, AM new to all this

Re: Hide expression column from pivot chart

jagannalla — Tue, 28 Aug 2012 10:22:06 GMT

Hello,

Small information for you, The person who says the right answer(i.e, his post) mark it as correct. If his information is helpfull then mark it as helpful.

Re: Hide expression column from pivot chart

Tue, 28 Aug 2012 10:28:53 GMT

I posted another discussion, can you please help, its about creating a specific graph

Re: Hide expression column from pivot chart

jagannalla — Tue, 28 Aug 2012 10:44:09 GMT

Ok i'll try give that link. Please change the correct answer to my post.