topic Re: If two dates match in QlikView

If two dates match

darren_dixon — Sat, 13 Jul 2013 14:20:36 GMT

Hi,

Script:

[Table 1]:

Date(DateA) AS DateA,

Balance,

[Table 2]:

Date(DateB) AS DateB,

Target,

I'm trying to get a straight table which shows:

Date | Balance | Target

Thanks for your help,

Darren

Re: If two dates match

hic — Sat, 13 Jul 2013 15:26:36 GMT

All you need to do is to name the two dates the same, e.g.

Date(DateA) AS Date,

Date(DateB) AS Date,

HIC

Re: If two dates match

somenathroy — Sat, 13 Jul 2013 15:30:39 GMT

Hi,

If possible you can concatenate two tables like below:

Output:

LOAD

Date(DateA) AS Date,

Balance,

........

Concatenate(Output)

LOAD

Date(DateB) AS Date,

Target,

Then in a straight table add Date as dimesion and use Balance & Target in expression.

Regards,

Som

Re: If two dates match

darren_dixon — Sat, 13 Jul 2013 15:56:22 GMT

Ideally, I was hoping for an expression which may solve this.

I can't rename the fields to be the same as this would cause a loop

Re: If two dates match

nagaiank — Sat, 13 Jul 2013 21:03:31 GMT

Try the following script:

TempOutput:

LOAD

Date(DateA) AS Date,

Balance,

........

Concatenate(Output)

LOAD

Date(DateB) AS Date,

Target,

Output:

NoConcatenate Load Date, Sum(Balance) as NewBalance, Sum(Target) as NewTarget

Resident TempOutput Group By Date;

Drop table TempOutput;