topic Re: Need help on data association. in QlikView

Need help on data association.

agni_gold — Tue, 16 Jun 2015 07:00:40 GMT

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.

Re: Need help on data association.

avinashelite — Tue, 16 Jun 2015 07:05:35 GMT

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 .

Re: Need help on data association.

ankit777 — Tue, 16 Jun 2015 07:54:09 GMT

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?

Re: Need help on data association.

awhitfield — Tue, 16 Jun 2015 08:21:46 GMT

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

Re: Need help on data association.

Gabriel — Tue, 16 Jun 2015 08:50:38 GMT

Hi,

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

Re: Need help on data association.

sgrice — Tue, 16 Jun 2015 09:30:10 GMT

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

NUM(LINEID) as LINEID

on both sales and Invoice.

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

Re: Need help on data association.

agni_gold — Tue, 16 Jun 2015 18:08:05 GMT

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

Re: Need help on data association.

sgrice — Wed, 17 Jun 2015 08:13:03 GMT

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);

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