Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Budget vs. Actual

Dear all,

I'm going to be crazy. I've to tables:

Budget

YEAR      Month     Category     QtyBudget

2011         10        AAA          10

2011         11        BBB          12

2011          9        CCC           5

Actual

YEARA     MonthA     Family     SalesQty

2011         5         AAA          12

2011        10         AAA          5

2011         7         BBB          5

2011        11         DDD          15

I'd like to merge them but I don't know how. I tried by join, concatenate, but it doesn't work fine.

Does anybody have any good trip in order to help me ?

Thanks in advance

1 Reply
Not applicable

Budget vs. Actual

Try this

Budget:

Load * Inline [

YEAR  ,    Month  ,   Category  ,   QtyBudget

2011  ,       10   ,     AAA   ,       10

2011  ,       11    ,    BBB  ,        12

2011  ,        9     ,   CCC ,          5] ;

Outer Join(Budget)

Load * Inline [

YEAR ,    Month     ,Category ,    SalesQty

2011  ,       5    ,     AAA   ,       12

2011  ,     10    ,     AAA     ,     5

2011   ,      7  ,       BBB     ,     5

2011    ,    11 ,        DDD      ,    15] ;

Or this

Load * , 'Budget' as Indicator Inline [

YEAR  ,    Month  ,   Category  ,   Value

2011  ,       10   ,     AAA   ,       10

2011  ,       11    ,    BBB  ,        12

2011  ,        9     ,   CCC ,          5] ;

Concatenate LOad * , 'Actual' as Indicator Inline [

YEAR ,    Month     ,Category ,    Value

2011  ,       5    ,     AAA   ,       12

2011  ,     10    ,     AAA     ,     5

2011   ,      7  ,       BBB     ,     5

2011    ,    11 ,        DDD      ,    15] ;

JJ

Community Browser