Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have data loaded in the qlik which is Table 1.
so i want to remove the row which is zero in the Confirm Quantity.
please suggest
Tabel 1
Order Number | Schedule Line Number | Material_Code | Material Name | Confirm Qty |
1234 | 2 | 10C39 | Wooden Box | 2 |
1234 | 1 | 10C39 | Wooden Box | 0 |
3456 | 2 | 39C34 | Glass | 1 |
3456 | 1 | 39C34 | Glass | 0 |
9805 | 2 | 56C34 | Cotton | 5 |
9805 | 1 | 56C34 | Cotton | 0 |
Final table like this
Order Number | Schedule Line Number | Material_Code | Material Name | Confirm Qty |
1234 | 2 | 10C39 | Wooden Box | 2 |
3456 | 2 | 39C34 | Glass | 1 |
9805 | 2 | 56C34 | Cotton | 5 |
You can do this when loading data by adding the clause where Confirm Qty <> 0, or with a set analysis in a measure of your table {<[Confirm Qty] -= {"0"}>}.
Kind regards,
Théo ATRAGIE.
You can do this when loading data by adding the clause where Confirm Qty <> 0, or with a set analysis in a measure of your table {<[Confirm Qty] -= {"0"}>}.
Kind regards,
Théo ATRAGIE.
Thank you
You welcome,
Have a nice day.