Missing data in chart or list box, available in the table

[absekrafi]

Dear Qlikview community,

I have 2 fact Tables. I linked them with a Link Table (first test) and with composite key (second test).

The field I want to display is BUDGET (please see the enclosed picture). As you can see in the preview value for the key 310-4-2012-5-12 is existing and it's equal to 1823,544 but when I added a chart and a simple list selection box, I am not able to find this value. (It's the same case for other values in a diffrent year).

The link key between the to fact tables is ; CODUSN&'-'&CODU&'-'&ANNEE&'-'&MOIS&'-'&CODPROD AS BudgetMoisCodeKey,

where:

CODUSN: factory code

CODU: unit code

ANNEE: year

MOIS: month

CODPROD: product code.

Do you have an idea why the field BUDGET values got removed? and did I make mistake that led to this issue?

Kind regards,

Abdallah

[absekrafi]

Hi Shivesh,

I succeeded to join my table to the fact table and now I have alla months data.

Thank you very much,

Abdallah

[shiveshsingh]

Glad to know it worked