Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

union different dimension with same names

Hello everyone,

I have the following problem:

I have 2 straight table charts:

1) Dimension: moth name of "claim_started" from a table

    Expression: sum(amount_eur)

2) Dimension: month name of "reserve_date" from another table

    Expression: sum(reserve_eur)

What I would like to do is to union somehow this 2 tables, because the dimension names are the same (Jan,Feb,Mar...) even if they refer to different date fields and to keep the Expressions values identically...

EX:

1)

month(claim_started)   Value1

Jan                             134

Feb                             12

Mar                             23

...                               ...  

2)

month(reserve_date)   Value2

Jan                         33

Feb                         544

Mar                         44

...

And the result table must look like:

month     Value1     Value2

Jan          132          33

Feb          12            544

Mar          23            44

...

Thank you very much,

Silviu

1 Solution

Accepted Solutions
hencovanee
Contributor II

Re: union different dimension with same names

Hi Silviu,

Find attached an example document on how to create a link table with a mastercalendar. This will solve the problem for you.

Kind regards,

Henco

5 Replies
Not applicable

union different dimension with same names

You could try creating a master calendar, linking the main table by claim_started and then resident load the same table and link it to the master calendar by reserve_date

mphekin12
Valued Contributor

union different dimension with same names

You could use a JOIN statement.  Something like the following should work for you:

tblTest:

LOAD * INLINE [
Month, Value1
Jan, 134
Feb, 12
Mar, 23
]
;


JOIN
LOAD * INLINE [
Month, Value2
Jan, 33
Feb, 544
Mar, 44
]
;

hencovanee
Contributor II

Re: union different dimension with same names

Hi Silviu,

Find attached an example document on how to create a link table with a mastercalendar. This will solve the problem for you.

Kind regards,

Henco

Not applicable

union different dimension with same names

Thank you all for you're help.

I will try to use you're solution, and if it still won't work, I'll post back.

Best regards,

Silviu.

hencovanee
Contributor II

union different dimension with same names

Oké, good luck. Would you please mark the answers as helpful or correct please

Kind regards,

Henco

Community Browser