Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Sorting Issue

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

 

6 Replies
Highlighted
Contributor III
Contributor III

Re: Sorting Issue

Please share a screenshot to be clearer.

Highlighted
Creator II
Creator II

Re: Sorting Issue

Please find the screen shot.

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

Highlighted
Contributor III
Contributor III

Re: Sorting Issue

What is your current sorting?
Highlighted
Creator II
Creator II

Re: Sorting Issue

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

Thanks,

Sarif

Highlighted
Contributor III
Contributor III

Re: Sorting Issue

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

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

Highlighted
Creator II
Creator II

Re: Sorting Issue

I did not get any function like this.

Could you please elaborate.

Thanks,

Sarif