topic Re: Filter tables data on condition in QlikView

Filter tables data on condition

krish2459 — Sat, 16 Nov 2024 20:17:43 GMT

Hi,

We have two tales Schedule Lines and Detail.

We need to pull quantity from Schedule line table where Purchase document and Item from detail table matches with Purchase document and Item Schedule line table.

Attached is the data sample.

Below is the excel logic in source file for reference.

=SUMIFS('Schedule Lines'!$J$1:$J$1353,'Schedule Lines'!$A$1:$A$1353,PO_Detail!A1058,'Schedule Lines'!$B$1:$B$1353,PO_Detail!B1058)

where J = quantity

A= purchase document

B= Item.

Thanks,

Re: Filter tables data on condition

krish2459 — Fri, 09 Aug 2019 11:39:31 GMT

Any Suggestions please.

Thanks..

Re: Filter tables data on condition

jensmunnichs — Fri, 09 Aug 2019 12:04:42 GMT

Hey,

Maybe something like this? (See attached qvw)

Had to separate the two tables in your Excel sheet, hence the Excel attachment.