Excluding zero amounts from separate columns in data tables

Fri, 02 Oct 2015 16:41:07 GMT

I have an expression applied to a multibox to exclude Free bookings:

=if(NETNET<>0,'Paid bookings','Free Bookings')

This works when only viewing data found in NetNet

We also have a variable on the report to exclude or include production charges and is associated to the script where if it has a value it is included, but if it is zero it is excluded

Is it possible the expression in the multibox can apply to both NetNet and Production Amounts ignoring the selections made to the variable?

I have tried:

=if((NETNET+PRODUCTION_AMOUNT)<>0,'Paid bookings','Free Bookings')

And the expression is ok, however when the production amount is zero it excludes the Net Net also.

any help would be appreciated

Re: Excluding zero amounts from separate columns in data tables

cjohnson — Fri, 02 Oct 2015 18:39:43 GMT

Hi Tez,

Can you put this field in the script? What happens if you put the following in the script:

LOAD

if((NETNET+PRODUCTION_AMOUNT)<>0,'Paid bookings','Free Bookings') as NewField

FROM

QVD;

You can then use this field in your multibox.

Thanks,

Camile

topic Re: Excluding zero amounts from separate columns in data tables in QlikView

Excluding zero amounts from separate columns in data tables

Re: Excluding zero amounts from separate columns in data tables