Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

dmelillo
Contributor II

ID and Date Link

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

3 Replies
kkkumar82
Valued Contributor III

Re: ID and Date Link

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?

rohitraut
Contributor

Re: ID and Date Link

Hello Dave,

Try this,

Table1:

Load

SalesPersonId,

Period,

Sales

From abc;


Concatenate(Table1)


Load

SalesPersonId,

Period,

Ramp%


From xyz;



Re: ID and Date Link

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%


Community Browser