topic Re: Data Not Matching with the data base and App in QlikView

Data Not Matching with the data base and App

vikas_nandanwar — Tue, 19 Dec 2017 03:51:13 GMT

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

Re: Data Not Matching with the data base and App

devarasu07 — Tue, 19 Dec 2017 04:40:30 GMT

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

Re: Data Not Matching with the data base and App

vikas_nandanwar — Tue, 19 Dec 2017 04:50:10 GMT

This worked.

But why is this happening?

Why did my script didn't worked?

Re: Data Not Matching with the data base and App

devarasu07 — Tue, 19 Dec 2017 06:32:27 GMT

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