Need help on data association.

[agni_gold]

I have 2 Fact and 2 Dimension tables above is the structure of the my data model. Two facts are linked with line ID , and customer and product is my dimension tables.

Now when I am creating a straight table with the columns of Customer, Product, Sales table there are blank rows also coming. Same happen when I am creating the straight table with all four tables ,

If I select any customer which is not linked with sales table , the straight table shows only customer name and rest columns are blank and my amount field is also comes with 0 value. same is happen with product also .

Please help.

[avinashelite]

Hi Agnivesh,

Your data model looks good , I think you don't have the data, that's why your getting blank row.

If you want to avoid the blank rows try to reduce the data in the script by using joins .

[ankit777]

Blank rows will come when u don't have data corresponding to some value. what is the issue you are facing? You want to remove the nulls?

[awhitfield]

Hi,

from the description, this suggests that some customer do not have invoices against them,  so other dimensions and expression values will not be populated; this is the correct expected behaviour.

HTH

Regards, Andy 

[Gabriel]

Hi,

I think if you try and merge the 2 FACT table you have might h

[sgrice]

Without seeing your data it is hard to Know but it could be that the ID fields that you are loading are being interpreted differently by qlikview. [One Table has TEXT the other has number]

When loading the id field try making both sides TEXT or NUMBER

i.e.

TEXT(LINEID) as LINEID

or

NUM(LINEID) as LINEID

on both sales and Invoice.

Note that Qlikview will associate fields of same name and is CASE sensitive.

[agni_gold]

yes but there are lot of customer but all customer may not be present in sales order fact .

[sgrice]

So either you want to limit the Customer table to only those with sales.

Load sales table first

then load Customer

with

LOAD .......

FROM ........qvd

WHERE EXISTS(CustomerID);

Or

When creating a chart with SUM(SALES) have suppress Zero Values and suppress Missing ticked [on presentation tab].