Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is it possible to add something to the script to have only DISTINCT lines on an order number? I didn't succeed and I would need it, if someone knows how. As an example, I took the order PO0000992, which has line 2 twice. I attached the model, the script and a printscreen if it helps. Thank you very much in advance
script below:
Hi, it shows 2 lines because the query retuns two lines, one with TranDate 2/10/23 and another with null. Also both rows have different values in at least LineNbr_PORL and ReceiptDate.
You can add before "Join1: ":
LOAD * Where not Exists(LineNbr);
But only the first row of LineNbr will be loaded, wich maybe is not the one you want.
If you are not familiar with Qlik scripting maybe it will be better to solve it in the query.
Or analyze why this happens (probably a line served in 2 different transports) and change the presentation to show this.
Also check if the Order Qty is correct, you can tell if the value of each line 2 is duplicated of each one has to add his own qty.
Hi, it shows 2 lines because the query retuns two lines, one with TranDate 2/10/23 and another with null. Also both rows have different values in at least LineNbr_PORL and ReceiptDate.
You can add before "Join1: ":
LOAD * Where not Exists(LineNbr);
But only the first row of LineNbr will be loaded, wich maybe is not the one you want.
If you are not familiar with Qlik scripting maybe it will be better to solve it in the query.
Or analyze why this happens (probably a line served in 2 different transports) and change the presentation to show this.
Also check if the Order Qty is correct, you can tell if the value of each line 2 is duplicated of each one has to add his own qty.
🙏 Thank you very much, Rubenmarin! Now I understand why it can't be done. I will try to remove what is not needed from the interface. Many thanks once again!