Data Not Matching with the data base and App

[vikas_nandanwar]

Hi,

I am uploading two sheets of data in Qlik sense, My data is not matching with the excel.

I have attached my App and my data for the reference,

Can anybody check the error and let me know.

My Excel total is

Cert/Parcel	Sum of Cts	Sum of Value (USD)
Cert	7436.65	30190273.05
Parcel	114278.47	70215751.23

Thanks,

Vikas

[devarasu07 · Accepted solution]

Hi,

Try to use concatenate method

Fact:
LOAD
    OGC,
    Source,
    "Date",
    "Buyer Name",
    "Supplier Name",
    "Lab Name",
    Cts,
    "Credit Terms",
    "Value (USD)",
   'Cert' as Type
FROM [lib://Downloads/Downloads\Procurement.xlsx]
(ooxml, embedded labels, table is Certified);
Concatenate (Fact)
LOAD
    OGC,
    Source,
    "Date",
    "Buyer Name",
    "Supplier Name",
    Size,
    Quality,
    "Credit terms",
    Rejection,
    "Yes / No",
    Cts,
    "Value (USD)",
    'Parcel' as Type
FROM [lib://Downloads/Downloads\Procurement.xlsx]
(ooxml, embedded labels, table is Parcel);

Hope this helps to you

Regards,
Deva

[vikas_nandanwar]

This worked.

But why is this happening?

Why did my script didn't worked?

[devarasu07]

Hi,

You app script also working after concatenating cert & parcel fact. refer to the attached sample.

p.s: the reason i concatenate is because of each fact has one type of value with similar column name

Hope it's clear, help to close this thread by marking as correct and helpful. Thanks