Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
absekrafi
Creator III
Creator III

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

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,

AbdallahMissing data.bmp

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

T:

CrossTable(Month, Data, 3)

LOAD * FROM

[..\Desktop\Missing data Excel.xlsx]

(ooxml, embedded labels, table is Document_CH23);

View solution in original post

11 Replies
shiveshsingh
Master
Master

What is the expression in your chart long with the dimensions?

on which dimension the expression is not working?

can you share the data to check?

absekrafi
Creator III
Creator III
Author

Hi Shivesh,

- The expression is Sum(BUDGET)

- The dimensions are : ANNEE (Year), MOIS (month) and CODUSN (factory).

So far the expression is not working on the dimension MOIS (month) and I didn't chek the other dimensions.

I enclosed the data in qvd format. If you want I transform it to an other format please let me know.

absekrafi
Creator III
Creator III
Author

How to enclose an Excel file to the current discussion.

absekrafi
Creator III
Creator III
Author

shiveshsingh
Master
Master

plz check attached and let me know the requirement

absekrafi
Creator III
Creator III
Author

Hi Shivesh,

I am not able to find the attachement. Could you please re-attach it?

Kind regards,

Abdallah

shiveshsingh
Master
Master

pfa

absekrafi
Creator III
Creator III
Author

Hi Shivesh,

Can you send me the script in a Wordpad file please.

Thank you,

Abdallah

shiveshsingh
Master
Master

T:

CrossTable(Month, Data, 3)

LOAD * FROM

[..\Desktop\Missing data Excel.xlsx]

(ooxml, embedded labels, table is Document_CH23);