topic Re: Sorting Issue in QlikView

Sorting Issue

mhmmd_srf — Sat, 16 Nov 2024 05:14:50 GMT

Hi All,

I have straight table.

I have Invoice, Po and PO Line. Where under 1 Invoice there could be multiple PO Line. Same posting is repeating for each PO Line against same Invoice.

I want to Show Invoice Posting Field only against PO Line 1.

How can I do this.

Please help.

Thanks,

Sarif

Re: Sorting Issue

sonkumamon — Thu, 15 Nov 2018 09:08:15 GMT

Please share a screenshot to be clearer.

Re: Sorting Issue

mhmmd_srf — Thu, 15 Nov 2018 09:13:06 GMT

Please find the screen shot.

The value 1019489.16 should be in first line against PO Line 1

Re: Sorting Issue

sonkumamon — Thu, 15 Nov 2018 09:22:17 GMT

What is your current sorting?

Re: Sorting Issue

mhmmd_srf — Thu, 15 Nov 2018 09:45:46 GMT

I have attached QVW file in initial post. Could you please check.

Thanks,

Sarif

Re: Sorting Issue

sonkumamon — Thu, 15 Nov 2018 10:02:56 GMT

You better flag the first line of each invoice in the load script and then try:

Sum{<isFirstLineInInlvoice={1}>} InvoicePostingAmount)

Re: Sorting Issue

mhmmd_srf — Thu, 15 Nov 2018 10:26:13 GMT

I did not get any function like this.

Could you please elaborate.

Thanks,

Sarif