Discussion Board for collaboration on QlikView Scripting.
I need to add target amount which is ordered by salesperson and date (Month and Year)
How can I import this ? My targets are in Excel with
Target_Month, Target_Year ( ---> Targets are in Amount)
The other basic table:
Salesperson, Date, AccountNo, Amount,.
load DocNo,Salesperson, Date, AccountNo, Amount,
MonthStart(Date) as Target_Month,
YearStart(Date) as Target_Year
load Salesperson, Date, Target_Month, Target_Year
(ooxml, no labels, table is Sheet1);
Well, my fault..
I want to add the targets by month and years per salesperson like
at the end, I want to get this
Generally Targets are more likely Monthly or Yearly. In your file have both seems to be both are same. If you have different month & year targets you can load two targets separately in same tables.
// First Load the Monthly Targets.
SalePerson & '|' &MonthStart(Date) AS %Key_TargetMonthly,
SalePerson & '|' &YearStart(Date) AS %Key_TargetYearly,
Create the %Key_TargetMonthly & %Key_TargetYearly in you fact table with same functions.
Please note that, year targets on Year level & Month target on Month level.