topic Re: hideing rows in QlikView

hideing rows

Fri, 31 Jan 2014 15:08:33 GMT

hello,

i have a straight table with 2 dimensions and multiple expressions. on the 3rd column i have an expression that can be either 0 or 1.

i need to hide all the rows in this table which have a 0 value on the 3rd expression

any ideas?

thanks!

Re: hideing rows

giakoum — Fri, 31 Jan 2014 15:10:26 GMT

Properties -- > Presentation tab

Show / Hide column

Re: hideing rows

Peter_Cammaert — Fri, 31 Jan 2014 15:12:24 GMT

In all expression columns, force a NULL value whenever this 3rd column evaulates to 0. The rows will disappear automagically.

For example, this could be expression in column 2:

if (Column3 <> 0, Sum(WhateverNeedsToBeAdded))

Peter

Re: hideing rows

Gysbert_Wassenaar — Fri, 31 Jan 2014 15:12:44 GMT

You need to include the expression of the third column in an if statement of the other expressions (or in a calculated dimension). For example for column 1: if( column(3) =1 , sum(SomeThing) )

Re: hideing rows

giakoum — Fri, 31 Jan 2014 15:14:43 GMT

sorry, did not read the question correctly!

I would go with Gysbert's suggestion.

Re: hideing rows

Peter_Cammaert — Fri, 31 Jan 2014 15:16:53 GMT

Well, my trick uses column labels instead of column indices. Continues working if you start moving around your expression columns. "Column3" or whatever you choose is the label of the column with expression 3.

Peter

Re: hideing rows

Fri, 31 Jan 2014 15:27:34 GMT

thanks for the reply. the problem here is that the third column is a function of all the other 10 columns in the table...

is there a way to achieve this using dimension limit?

thanks

Re: hideing rows

Gysbert_Wassenaar — Fri, 31 Jan 2014 15:33:48 GMT

Dimension limits uses the values of the first expression. So you'd have to move the expression in the third column the first position. Or make a copy of it, move it so it becomes the first expression and then hide it (on the Presentation tab). In the Dimension Limits you could then choose to show only values greater than the exact amount 0.

Re: hideing rows

Fri, 31 Jan 2014 15:40:03 GMT

i tried that, but i keep getting the "allocated memory exceeded" error.

i have 2 dimensions in the table. i'm using qlik version 11.2

any ideas?

Re: hideing rows

giakoum — Fri, 31 Jan 2014 15:42:21 GMT

a sample application might help, if possible.