topic Data Model Issue in QlikView

Data Model Issue

vanderson009 — Tue, 05 May 2015 17:12:20 GMT

Hi Community,

I have query regarding data model.

I have product table with productname and sales field, but i dont have month field as like :

but i want to add month field in that table like :

How can i achieve this, please help me.

Thanks,

Villyee

Re: Data Model Issue

Gysbert_Wassenaar — Tue, 05 May 2015 17:16:06 GMT

Table1:

LOAD ProductName, Sales

FROM ...

JOIN (Table1)

LOAD * INLINE [

Month

Jan

Feb

Mar

];

Re: Data Model Issue

Anonymous — Tue, 05 May 2015 17:17:11 GMT

Would something like this help ?

Data :

LOAD * INLINE [

ProductName, Sales

A, 100

B, 150

C, 120

];

outer join (Data)

LOAD * INLINE [

Month

Jan

Feb

Mar

];

Re: Data Model Issue

mohammadkhatimi — Wed, 06 May 2015 07:18:58 GMT

Table1:

LOAD ProductName, Sales

FROM ...

JOIN (Table1)

LOAD * INLINE [

Month

Jan

Feb

Mar

Apr

May

];

Hope this Helps you.

Regards,

Mohammad