topic Commenting out in a Cross Table in QlikView

Commenting out in a Cross Table

Wed, 24 Jul 2013 18:32:08 GMT

I have multiple tables with 1 or 2 fields in common that i need to all link, however i get a synthetic key or loop everytime i reload. I tried to make a key to fix this, but since some of my tables are cross tables i dont think i can comment out the main, named field to do that - in this case "Month_Ref". Any suggestions?

Ex.

Table1:

Crosstable (Month_Ref, Forecast, 2)

Material,

Plant,

Month 1,

Month 2,

Month 3

Table 2:

Crosstable (Month_Ref, Shipments, 2)

Material,

Store#,

Month1,

Month2,

Month3

CalendarTable:

Month_Ref

MasterTable:

Material

Really appreciate the help!

Parrish

Re: Commenting out in a Cross Table

Wed, 24 Jul 2013 18:37:50 GMT

Another note to add would be the the CalendarTable: Month_Ref also has fields that would link to Month_Ref in the other tables to then show date as text depending on the particular month number (Month1, Month2, Month3), or month date in actual date format, etc. So, with this being said, i do not believe that i should rename the Month1, Month2, and Month3 fields as it may jeopardize my Calendar.

Re: Commenting out in a Cross Table

Anonymous — Thu, 25 Jul 2013 15:22:47 GMT

hello,

I wait help you, try this

Table1:

Crosstable (Month_Ref, Forecast, 2)

Material,

Plant,

Month 1,

Month 2,

Month 3

Table 2:

Crosstable (Month_Ref, Shipments, 2)

Material,

Store#,

Month1,

Month2,

Month3

Table1:

LOAD AutoNumber(Material&'_'&Month_Ref) as Id_Tabla,

Material,

Plant,

Forecast,

Month_Ref

Resident Table1_tmp1;

DROP Table Table1_tmp1;

KeyTable:

LOAD Distinct Id_Tabla,

Material,

Month_Ref

Resident Table1;

DROP Field Material,

Month_Ref From Table1;

Table2:

LOAD AutoNumber(Material&'_'&Month_Ref) as Id_Tabla,

Material,

Store#,

Shipments,

Month_Ref

Resident Table2_tmp1;

DROP Table Table2_tmp1;

Concatenate(KeyTable)

LOAD Distinct Id_Tabla,

Material,

Month_Ref

Resident Table2;

DROP Field Material,

Month_Ref From Table2;

Re: Commenting out in a Cross Table

Gysbert_Wassenaar — Thu, 25 Jul 2013 16:21:32 GMT

You could simply concatenate the two tables. Or you could create a link table using the Qlikview Components library. See this discussion.