topic Re: Comparing two fields from two different table ? in QlikView

Comparing two fields from two different table ?

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

plz resolve the issue.

LOAD "Amount" AS Customer_Amount,

"Company Name",

"Document Type",

"Posting Date";

SQL SELECT "Amount",

"Company Name",

"Document Type",

"Posting Date",

FROM TestSqlDatabaseOne.dbo."Detailed Customer";

Purchase:

LOAD "Amount" as Purchase_Amount,

"Company Name",

"Linked Sales Invoice",

"Posting Date",

SQL SELECT "Amount",

"Company Name",

"Linked Sales Invoice",

"Posting Date",

"Shortcut Dimension 2 Code"

FROM TestSqlDatabaseOne.dbo."Purchase" Where [Linked Sales Invoice] <> ' ';

LOAD "Company Name",

Currency Code",

"Relational Exch_ Rate Amount",

"Starting Date";

SQL SELECT "Company Name",

"Currency Code",

"Relational Exch_ Rate Amount",

"Starting Date"

FROM TestSqlDatabaseOne.dbo."Currency" where "Currency Code"='INR';

Condition :

1. if(Posting date=Starting date and Document type=2) then Sum(Amount)/Sum(Relational Exch_Rate Amount) in table A is sales

2. If(Posting date=Starting date and Linked Sales Invoice=Document no) then Sum(Amount)/Sum(Relational Exch_Rate Amount) in table B is purchase

Relation: A.Document no=B.Linked Sales Invoice

A.Posting Date=B.Posting Date=C.Starting Date

Re: Comparing two fields from two different table ?

kkkumar82 — Wed, 20 Jul 2016 08:10:18 GMT

Hi Satish,

Based on the relations please alias the columns in the tables A, B,C and Observe in the table viewer if the tables are linked as per your relationships.

Please create a straight table as per this.

if not gettting please upload a sample qvw file.

Re: Comparing two fields from two different table ?

Gysbert_Wassenaar — Wed, 20 Jul 2016 08:10:39 GMT

Please don't clutter this site with duplicate discussions: How to compare two fields from two different tables

Re: Comparing two fields from two different table ?

Wed, 20 Jul 2016 09:58:27 GMT

Its was done by mistake.

Gysbert ignore this time.

Re: Comparing two fields from two different table ?

Wed, 20 Jul 2016 10:00:49 GMT

it didn't work dear.

i will add sample.