remove line with '0' in expression

[#1]

hello all,

i need your help in removing the lines where the expression quantity is zero (0).

I have a table as shown below where i have ranked the codes by their volume.

However i do not wish to have the lines where the Volume is 0. For me the table should only display those whose values are greater than 0 and be displayed as such

I have attached the qvw for your convenience.

Thanks in advance for your help and advices.

Regards,

Rajiv

[swuehl]

Try this as calculated dimension instead your current dimension:

=aggr(if(sum(volume),symptoms_code),symptoms_code)

Hope this helps,

Stefan

[Anonymous]

Or just dont load the information

You can do this by adding the following to your load script:

Where volume <> 0 ;

like:

LOAD symptoms_code,

     information,

     volume

FROM

E:\HCSC2516\Data\test1.xls

(biff, embedded labels, table is Sheet1$)

Where volume <> 0 ;

[#4]

it suits me, thanks swuehl..

can you please briefly describe me the calculated expression you suggested, i cannot realy understand its definition in help menu in QV.

[swuehl · Accepted solution]

My expression is equivalent to

=aggr(if(sum(volume)<>0,symptoms_code),symptoms_code)

so you could read it like this:

Group your records by symptoms_code, calculate the sum(volume) per symptoms_code. Return symptoms_code where the sum is not zero.

So you get a list of your symptoms_code values, but limited to your condition.

[#6]

thanks for the explanation.. got it

[#7]

good idea denis, however it can be applied for the example i gave, however in the app am working, the sum is calculated in the expression itself