How to skip showing a certain field or value when the table returns blank?

[Anonymous]

I created a NP template to show order information by order number and billing customer. For some billing customers, there could be no order data. See the highlighted part below, the billing customer 129 doesn’t have any order data. How could I skip showing it?

Also, I am attaching the template I am using...thanks!

[vinieme12]

change your Expression to show only orders with Quantity greater than 0

example: if(sum(Quantity)>0,sum(Quantity))

[sdmech81]

Hi,

While you load the inside exript you need to say :

Where Qty Ordered<>'0' ;

Suppose ex:

Load * from ........QVD  Where Qty Ordered<>'0' ;

Sachin

[vinieme12]

Hi Sachin,

This is not related to loading the data into qlikview .

The query is related to suppressing zero values in a pivot table , shown in an excel template created with Nprinting

[Anonymous]

Hi Vineeth,

My orders won't have a qty with 0. In QV doc, if I select the customer 129, there is no data displayed in the order table, which is fine. The problem is I don't want to see the billing customer appears when there is no order data for it in my NP report.

[sdmech81]

Oh ..

I tht case may be something like in set, if directly showing data

=Only({Quantity-='0'}Quantity)

or if u doing aggregation then something like:

=Sum({Quantity-='0'}Quantity)

Whr -= is fr not equal to

[vinieme12]

have you tried my earlier suggestion? we are restricting values by expression..

also try

if(isnull(sum(Qty) ),null(),sum(qty) and check suppress when value is null