Discussion board where members can get started with QlikView.
I need some help please for data modeling.
I would like to build a dashboard to help the sales team to keep track of their individual earnings on the 2017 Incentive scheme
I have bonus payment matrix, per country, which is defined by “band”. The bands are different for each country
For example, for the UK:
Progress through the band levels is based on cumulative sales volume for the individual through the year
If the individual achieves their quota for a given quarter, they receive a Kicker
The targets for the UK for example:
The Kicker for the UK:
I have my fact table where i have the volume (#SalesQty) where i have the SalesRep, the country and the salesdate.
I would like to :
Could you please help me to build my data model, how to link the volume to the bands,and how to calculate the metrics?
Many thanks by advance.