topic "Connect" two fields from 2 different tabels in QlikView

"Connect" two fields from 2 different tabels

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Lets say I have one table with

ID,

Date,

something else,

and another with

ID,

Tons,

something else(2),

How would i use the Date and Tons to calculate how many tons i have for a specific date

Re: "Connect" two fields from 2 different tabels

vishsaggi — Mon, 09 Jul 2018 18:35:50 GMT

Qlikview should automatically join both the tables based on common field ID. Can you show your data model and expr your are trying?

Re: "Connect" two fields from 2 different tabels

Anonymous — Mon, 09 Jul 2018 18:37:39 GMT

They have the line in between them but I just want to know what an expression like that would look like?

Re: "Connect" two fields from 2 different tabels

Anonymous — Mon, 09 Jul 2018 18:40:20 GMT

I need to Sum all of the tons for dates that are today.

Re: "Connect" two fields from 2 different tabels

Anonymous — Mon, 09 Jul 2018 18:40:56 GMT

so like IF(date = Today(), Sum(tons_actual))

Re: "Connect" two fields from 2 different tabels

vishsaggi — Mon, 09 Jul 2018 18:42:03 GMT

Ok. So is your Date field same format as Today() format? What is the issue you are facing. Any sample file to look into?

May be you can try like

= Sum(IF(Date = Today(), tons_actual)

Re: "Connect" two fields from 2 different tabels

Anonymous — Mon, 09 Jul 2018 18:53:25 GMT

=IF(Date(date_arrivee, 'dd/mm/yyyy') < Date(today(), 'dd/mm/yyyy'), Sum(tons_actual))

Re: "Connect" two fields from 2 different tabels

qlikviewwizard — Tue, 10 Jul 2018 04:25:01 GMT

Hi,

Try like this.

DATA_EMP:

LOAD ID,

// date(DATE#(Date,'MM/DD/YYYY')) as Date,

Date,

S1,

FROM

TEST_DATA.xlsx

(ooxml, embedded labels, table is Sheet1);

JOIN (DATA_EMP)

LOAD ID,

Tons,

S3,

FROM

TEST_DATA.xlsx

(ooxml, embedded labels, table is Sheet2);

NoConcatenate

DATA:

LOAD *, if(Date=Today(),Tons) as Today_Tons;

LOAD * Resident DATA_EMP;

DROP TABLE DATA_EMP;