topic filtering rows according to an exprssion in QlikView

filtering rows according to an exprssion

m4u — Tue, 15 Mar 2011 11:42:49 GMT

hi all,

i have a "straight table" with some dimensions, and 2 expressions:

Sum(CurrentItems)

sum(CurrentValue)

i want that when the first exprssion returns zero, the row will not appear on the table.

thakns for any Idea.

shlomo

matt_crowther — Tue, 15 Mar 2011 11:46:08 GMT

Create a Calculated Dimension something along the lines of:

=if(sum(CurrentIrems)>0,[Name of Dim])

Then set the dimension to 'Supress Where Null'.

That should do it.

Hope that helps,

Matt - Visual Analytics Ltd

m4u — Tue, 15 Mar 2011 11:57:03 GMT

Hi,

thanks

when trying to use an aggresation function (like sum(xxx)) as a dimension, the result is:

"// Error in calculated dimension"