topic remove line with '0' in expression in QlikView

remove line with '0' in expression

Fri, 13 Jan 2012 11:40:56 GMT

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

remove line with '0' in expression

swuehl — Fri, 13 Jan 2012 11:58:32 GMT

Try this as calculated dimension instead your current dimension:

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

Hope this helps,

Stefan

remove line with '0' in expression

Anonymous — Fri, 13 Jan 2012 12:20:20 GMT

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 ;

remove line with '0' in expression

Fri, 13 Jan 2012 12:30:30 GMT

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.

remove line with '0' in expression

swuehl — Fri, 13 Jan 2012 12:35:45 GMT

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.

remove line with '0' in expression

Fri, 13 Jan 2012 13:28:47 GMT

thanks for the explanation.. got it

remove line with '0' in expression

Fri, 13 Jan 2012 13:30:00 GMT

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