topic Re: Hiding Columns in QlikView

Hiding Columns

Anonymous — Fri, 10 Apr 2015 09:59:27 GMT

In a straight table I want to add 2 columns together in another column and hide the 2 original columns. In the calculated column I have put the expression column(2)+column(3). This adds the 2 columns together correctly, however when I try and hide columns 2 & 3 by ticking the conditional check box and putting 0 or disabling the expressions I just get an error.

Please help

Thanks

Re: Hiding Columns

jsanchezh — Fri, 10 Apr 2015 10:05:46 GMT

Hello,

The problem is that if you hide or disable them, then they are no longer column(2) and column(3). You can try one of this solutions and see if it works:

a) Name the expressions as Column2 and Column3 (or other names) and then in the expression for the new column write "=Column2 + Column3"

b) Write the complete expresion in the new column =expresion_column_2 + expression_column_3

I hope it's been helpful

Greetings!

Re: Hiding Columns

Anonymous — Fri, 10 Apr 2015 10:06:59 GMT

I think sharing the sample application is required or at least share the error message you are getting

have u added at least 1 expression

Re: Hiding Columns

Gabriel — Fri, 10 Apr 2015 10:07:48 GMT

Hi,

The expression in each of column 2 & column 3, is it possible to create the expression in the script. Which then gives you the flexibility to have a column 4 (combination of column(2)+column(3).)?

Re: Hiding Columns

Anonymous — Fri, 10 Apr 2015 10:09:27 GMT

I tried option (a) but with the same result. I'm trying to avoid option (b) as this would mean I will need 'if' and 'aggr' expressions

Re: Hiding Columns

Anonymous — Fri, 10 Apr 2015 10:10:25 GMT

try to Keep column(1) and column(2) enabled, BUT hide both columns under presentation

then the column(3) should show correct results

Re: Hiding Columns

Anonymous — Fri, 10 Apr 2015 10:12:34 GMT

Brilliant Thanks