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.
c_neumann
New Contributor II

Please assist with linking data or intervalmatch

Need to link Threshold Dimension to Fact Data between a Period and BU

Please assist with script

Fact has data per count/date/period/bu

Fact:

  

BUThresholdFrom PeriodTo Period
A10201601201601
A15201602999912
B10201601999912
C10201601

999912

Dimension //need to interval match this by period and bu

Dimension:

  

BUThresholdFrom PeriodTo Period
A10201601201601
A15201602999912
B10201601999912
C10201601999912
Tags (2)
4 Replies

Re: Please assist with linking data or intervalmatch

what is the result you would expect from matching these identical tables?

c_neumann
New Contributor II

Re: Please assist with linking data or intervalmatch

Hi Marco

Sorry the tables copied incorrectly for my question.

Fact has BU / Count Actual /  Period / Date

I want to have a Threshold from Dimension associated with fact by a From and To period (possibly intervalmatch)

i.e if you sum (Threshold) per BU Dimension for BU A your would see a graph of  10 for 201601 and a change to 15 from 201602 for BU = A

Question should have read:

Need to link Threshold Dimension to Fact Data between a Period and BU                                            

Please assist with script                               

                                            

Fact has data per count/date/period/bu                                                                          

Fact:                                                                             

BU          Count-Actual                     Period                  Date

A             2                                           201601                 2016-01-03

B             8                                           201601                 2016-01-04

C             16                                         201601                 2016-01-05

A             12                                         201602                 2016-02-03

B             11                                         201602                 2016-02-04

C             9                                           201602                 2016-02-05

                                            

                                            

Dimension //need to interval match this by period and bu                                         

                                            

Dimension:                                                                                 

BU          Threshold            From Period        To Period

A             10                          201601                 201601

A             15                          201602                 999912

B             10                          201601                 999912

C             10                          201601                 999912

stabben23
Honored Contributor

Re: Please assist with linking data or intervalmatch

stabben23
Honored Contributor

Re: Please assist with linking data or intervalmatch

this is better:

IntervalMatch

Community Browser