topic Hide rows null in QlikView

Hide rows null

Mon, 22 Nov 2010 10:01:38 GMT

Hello,

I want to hide NOT TO DELETE rows when value is null in a dimension of my straight table:

I have two dimensions in my table and my expression depend just of one of this dimensions.So, for the dimension product, my expression had a value just for the value "null".

I am using this expression: sum(total <dimension 1> expression) to I have a value for every product.

Because of this, when I remove the value null in a dimension, the value of my expression will be 0 for every product. --> but, I don't want to remove the value, just hide it.

It is possible?

Sorry for my english, my french is better

Hide rows null

Mon, 22 Nov 2010 10:45:58 GMT

I am not quite sure why you have a dimension against which you are not measuring, but could you use the 'aggr' function in the expression against both dimensions?

Regards,

Gordon

Hide rows null

Mon, 22 Nov 2010 11:49:09 GMT

It's work. Thank you.

Hide rows null

Mon, 22 Nov 2010 15:06:15 GMT

But, now I have another problem:

My expression is: aggr(sum(total <Dimension 1> expression), Dimension 1, dimension 2). So, now, the total in my straight table can't be calculate. What I can do?

Hide rows null

johnw — Tue, 23 Nov 2010 00:51:05 GMT

I'm not sure what you want, but maybe this?

Properties -> Expressions -> Total Mode -> Sum of Rows

Hide rows null

Tue, 23 Nov 2010 10:29:22 GMT

It isn't work because I have values "null" in my column

Hide rows null

Tue, 23 Nov 2010 10:55:45 GMT

sum(aggr(sum(total <Dimension 1> expression), Dimension 1, dimension 2)) should work