Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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?
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
SalesPersonId, Period, Sales
Load SalesPersonId, Period, Ramp%