topic Re: Table Po Wise Summation in QlikView

Table Po Wise Summation

nuwanhwb87 — Sun, 27 Dec 2020 03:00:50 GMT

Hi all,

I need to get the second table from the First table. The Available data set is the first table. Original Po number increase it's quantity by adding ' -A' at the end of PO . i need to sum the Original Po wise quantity.

Please help

Thanks

Re: Table Po Wise Summation

rubenmarin — Sun, 27 Dec 2020 10:42:45 GMT

Hi @nuwanhwb87, using subfield you can get the value until the first '-', so try Subfield([Po No],'-',1) to create the field that merges both values.

Maybe you need to use Text(Subfield([Po No],'-',1))