topic union different dimension with same names in QlikView

union different dimension with same names

Tue, 27 Mar 2012 17:41:15 GMT

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:

month(claim_started) Value1

Jan 134

Feb 12

Mar 23

... ...

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

union different dimension with same names

Tue, 27 Mar 2012 17:44:14 GMT

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

union different dimension with same names

mphekin12 — Tue, 27 Mar 2012 18:24:25 GMT

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
];

Re: union different dimension with same names

Anonymous — Tue, 27 Mar 2012 19:38:56 GMT

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

union different dimension with same names

Wed, 28 Mar 2012 07:49:46 GMT

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.

union different dimension with same names

Anonymous — Wed, 28 Mar 2012 07:51:18 GMT

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

Kind regards,

Henco