Discussion Board for collaboration on QlikView Scripting.
I want to insert a target table for salesperson by date and link that with the master calendar
How can I realize that ?
I Have all of my data in one table:
Salesperson & '|' & Date as %KEY_TARGET
Date (2012 - 2015, fictitious dates per Month and year once ..)
TargetMonthAmount, TargetMonthAmount*12 as TargetYearAmount ( OR TargetYearAmount, TargetYearAmount/12 as TargetMonthAmount)..no relevant which way.
My problem is, I can't join / combine the 2 Date table, even with Join ..
Perhaps you can concatenate the tables: Fact Table with Mixed Granularity