Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: insert targets (excel) by date

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


talk is cheap, supply exceeds demand
Community Browser