Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
darren_dixon
New Contributor III

If two dates match

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

4 Replies

Re: If two dates match

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

Date(DateA) AS Date,

Date(DateB) AS Date,

HIC

somenathroy
Contributor III

Re: If two dates match

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

Highlighted
darren_dixon
New Contributor III

Re: If two dates match

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

nagaiank
Valued Contributor III

Re: If two dates match

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;