Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

insert targets (excel) by date

Hello guys,

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:

ALL:

DocNo,

Date,

Salesperson,

Amount,

...

ExcelTarget:

Salesperson & '|' & Date as %KEY_TARGET

Salesperson,

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 ..

1 Reply
Gysbert_Wassenaar

Perhaps you can concatenate the tables: Fact Table with Mixed Granularity


talk is cheap, supply exceeds demand