Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
change your Expression to show only orders with Quantity greater than 0
example: if(sum(Quantity)>0,sum(Quantity))
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
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
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.
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
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