Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
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

Please share a screenshot to be clearer.

Highlighted
Creator II
Creator II

Please find the screen shot.

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

Highlighted
Contributor III
Contributor III

What is your current sorting?
Highlighted
Creator II
Creator II

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

Thanks,

Sarif

Highlighted
Contributor III
Contributor III

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

I did not get any function like this.

Could you please elaborate.

Thanks,

Sarif