Dear all
I have following types of report in Qlikview , I my report I want to show only Pending Order Qty , Zero (0) Pending qty I don't want to show in report in qlikview
How to show such report ?
| Location | Product Code | Product | SO No | SO Date | SO Value | Actual Qty | Recd Qty ( Invoice) | Pend Ord Qty | Pend Ord Val |
| BHIWANDI | ABC | TABLETS | ORD/14-15-BI/7087 | 04/11/2014 | 360 | 50 | 50 | 0 | 0 |
| PQR | SYRUP | ORD/14-15-BI/7091 | 04/11/2014 | 2,262 | 30 | 0 | 30 | 2261.7 |
| ABC | CREAM (INST) 30G | ORD/14-15-BI/7093 | 04/11/2014 | 1,68,768 | 9350 | 9350 | 0 | 0 |
| XYZ | CREAM (INST) 30G | ORD/14-15-BI/7094 | 04/11/2014 | 90,070 | 4990 | 4990 | 0 | 0 |
| PPP | CAPSULES | ORD/14-15-BI/7098 | 06/11/2014 | 1,508 | 20 | 20 | 0 | 0 |
| QQQ | SYRUP | ORD/14-15-BI/7098 | 06/11/2014 | 2,668 | 50 | 50 | 0 | 0 |
| RRRR | EYE/EAR DROPS | ORD/14-15-BI/7099 | 06/11/2014 | 986 | 60 | 60 | 0 | 0 |
| AAA | CAPSULES | ORD/14-15-BI/7099 | 06/11/2014 | 294 | 10 | 10 | 0 | 0 |
| 12323 | EYE/EAR DROPS | ORD/14-15-BI/7100 | 06/11/2014 | 235 | 10 | 0 | 10 | 235.2 |
| 1233 | TABLETS | ORD/14-15-BI/7100 | 06/11/2014 | 768 | 2 | 2 | 0 | 0 |
Vikas
Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
