topic Re: Hide Column in QlikView

Hide Column

Mon, 24 Jun 2013 16:36:49 GMT

Hello,

I'd like to show the first one, which is a sum, the other three columns, and then hide the others, without removing their values from the query.

Should I write something like

If(ColumnNo()>4, #ExpressionToHide#, )

I've attached my example.

I'd like to show only columns 0,1,2,3.

Thanks in advance.

Michele

Tue, 25 Jun 2013 06:06:18 GMT

I am not clear with your problem.
Can you please elaborate a bit which all columns you want to see and which not?

Tue, 25 Jun 2013 06:33:28 GMT

Hi,

You have an option to hide column in the presentation tab of the chart properties.

Thanks

Tue, 25 Jun 2013 07:10:21 GMT

You can apply condition in Expressions in chart property by cliking conditional check box.

Request you to brief your requirment little more clear

Tue, 25 Jun 2013 07:42:22 GMT

Hi,

As u have taken pivot table,there is no hide option available in properties.

i have seen ur chart ..pls go through process.

Properties >Dimension>Just check "Suppress when value is null"

Hope it will help u..

Tue, 25 Jun 2013 08:27:24 GMT

Sorry for not being clear, I'm a newbie.

I have currently this situation

I would like it to be

When I check for "ColumnNo()", they have values 0,1,2,3

Thank you.

Michele