topic Re: Hiding Columns in QlikView

Hiding Columns

Anonymous — Fri, 14 Mar 2014 09:24:54 GMT

Is it possible in a straight or pivot table to hide columns when they total zero?

Thanks

Re: Hiding Columns

MK_QSL — Fri, 14 Mar 2014 09:27:27 GMT

If total = 0 why you include them in your expression or dimension?

I hope you are talking about hiding columns ...

If this is so, go to presentation tab and select Suppress Zero-Values

Re: Hiding Columns

Fri, 14 Mar 2014 09:28:27 GMT

Hi,

In Presentation tab, you can add a condition to show the column when it is not null or zero else hide it.

Re: Hiding Columns

Anonymous — Fri, 14 Mar 2014 09:32:14 GMT

I have a table with a lot of expressions which can be zero depending on what is selected. I just wanted to save space by hiding the column when it is zero

Re: Hiding Columns

Anonymous — Fri, 14 Mar 2014 09:33:14 GMT

Can you show an example?

Thanks

Re: Hiding Columns

Fri, 14 Mar 2014 09:42:55 GMT

I have a straight table, where if Circuit count is zero, I want to hide that column.

Here is the conditional show applied in presentation tab.

Similar way, you can add condition for expression too.

Re: Re: Hiding Columns

SunilChauhan — Fri, 14 Mar 2014 09:55:26 GMT

see the attached file where column2 is hidden

using presention tab in chart properties

hope this helps

Re: Hiding Columns

MK_QSL — Fri, 14 Mar 2014 09:59:28 GMT

You can go to presentation tab where

Show Column

Hide Column

Conditional

features available.

You can select respective column and select any one of above...

Re: Hiding Columns

jonathandienst — Fri, 14 Mar 2014 10:00:06 GMT

Do you want to hide a row when all the columns sum to a total of 0?

Suppress zeroes wont work in such a case. You first need to change the expressions something like this:

Assuming n expressions in the table:

=If(RangeSum(Column(1), Column(2),....Column(n)) <> 0, <your expression1>, 0)

=If(RangeSum(Column(1), Column(2),....Column(n)) <> 0, <your expression2>, 0)

=If(RangeSum(Column(1), Column(2),....Column(n)) <> 0, <your expressionn>, 0)

The rangesum should include all the column numbers you want to consider for your condition.

<your expressionn> is your existing expression 1 to n

Now suppress zeroes will cause these rows to be hidden.

HTH

Jonathan

Re: Hiding Columns

Fri, 14 Mar 2014 10:01:34 GMT

In the expressions window, for the particular expression (let's say it is sum of Data), you can write a expression in the 'Conditional' box as..

=If(Sum(TOTAL Data)=0,0,1)

Re: Hiding Columns

Anonymous — Fri, 14 Mar 2014 10:09:06 GMT

Thanks, these seems to work

Re: Re: Hiding Columns

its_anandrjs — Fri, 14 Mar 2014 10:12:38 GMT

Hi,

Do this thing

In chart properties -> presentation -> then select which column you want to hide and in conditional option write code

if(FieldName <> 0,1,0)

Hope this helps

Thanks & Regards