topic Re: ID and Date Link in QlikView

ID and Date Link

Anonymous — Thu, 14 Sep 2017 13:24:42 GMT

I have two data sets:

1st data set has SalesPersonId, Period, Sales

2nd data set has SalesPersonId, Period, Ramp%

I am trying to create a graph that tracks Sales and Ramp% for each Salesperson on a graph. I would like to show two lines, per SalesPerson Id, that show Sales and Ramp% over the same PERIOD.

My script is pretty basic, and I just have a synthetic key joining these two sets at the moment, but I am not getting the desired effect.

Any help is appreciated.

- dave

Re: ID and Date Link

kkkumar82 — Fri, 15 Sep 2017 07:50:54 GMT

Join the two tables with the common columns in both the tables, it will resolve the synthetic keys, do you have any other columns in both the tables?

Re: ID and Date Link

rohitraut — Fri, 15 Sep 2017 10:02:18 GMT

Hello Dave,

Try this,

Table1:

Load

SalesPersonId,

Period,

Sales

From abc;

Concatenate(Table1)

Load

SalesPersonId,

Period,

Ramp%

From xyz;

Re: ID and Date Link

its_anandrjs — Fri, 15 Sep 2017 10:14:09 GMT

Try to join those tables with the keys that you get in the Synthetic Tables or go for Concatenation.

With JOINS but be careful about the Key fields

Table1:

Load

SalesPersonId, Period, Sales

Join(Table1)

Load SalesPersonId, Period, Ramp%

With Concatenation

Table1:

Load

SalesPersonId, Period, Sales

Concatenate(Table1)

Load SalesPersonId, Period, Ramp%