topic Re: How to get Max date for Two straight table in QlikView

How to get Max date for Two straight table

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

Hi All ,

I have data like below

STRAIGHT TABLE 1 :

DATE	PRODUCT
4/25/2017 9:13:30 PM	A
4/25/2017 9:12:11 PM	A
4/25/2017 9:12:30 PM	A
4/25/2017 9:11:29 PM	A
4/25/2017 9:11:45 PM	A
4/25/2017 9:12:46 PM	A
4/25/2017 9:13:06 PM	A

STRAIGHT TABLE 2:

DATE	PRODUCT
4/18/2017 11:02:31 AM	B
4/18/2017 11:00:54 AM	B
4/18/2017 11:01:22 AM	B
4/18/2017 11:02:01 AM	B
4/18/2017 11:00:12 AM	B
4/18/2017 11:00:28 AM	B
4/18/2017 10:58:52 AM	B
4/18/2017 10:59:52 AM	B
4/18/2017 11:01:35 AM	B
4/18/2017 11:02:18 AM	B
4/12/2017 9:57:03 PM	B
4/12/2017 9:51:51 PM	B

here I want to fetch Max Date from both tables individually , Now I am able to get get for one table only i.e 4/25/2017 9:13:30 PM

i need second straight table max date also i.e 4/18/2017 11:02:31 AM Finally want to display both tables max dates along with Product Names separately

Regards,

Re: How to get Max date for Two straight table

sunny_talwar — Thu, 27 Apr 2017 13:16:49 GMT

What are the expressions in your two straight table?

Re: How to get Max date for Two straight table

sunny_talwar — Thu, 27 Apr 2017 13:17:22 GMT

May be like this

Max({<PRODUCT = {A}>}DATE)

Max({<PRODUCT = {B}>}DATE)

Re: How to get Max date for Two straight table

Anonymous — Thu, 27 Apr 2017 13:34:14 GMT

Hi Sunny

just trying with dummy expression

Here need to display only one max date

Regards,

Re: How to get Max date for Two straight table

sunny_talwar — Thu, 27 Apr 2017 13:50:01 GMT

Not sure I understand

Re: How to get Max date for Two straight table

ziadm — Thu, 27 Apr 2017 14:51:55 GMT

TABLE1:

load * inline [

MyDate, PRODUCT

4/25/2017 9:13:30 PM, A

4/25/2017 9:12:11 PM, A

4/25/2017 9:12:30 PM, B

4/25/2017 9:11:29 PM, B

4/25/2017 9:11:45 PM, B

4/25/2017 9:12:46 PM, B

4/25/2017 9:13:06 PM, B

];

MinMax:

load

PRODUCT,

num(Max(MyDate)) as MaxDate,

num(Min(MyDate)) as MinDate

Resident TABLE1

Group by PRODUCT;

Same thing for TABLE2 and concatenate both