Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
This worked.
But why is this happening?
Why did my script didn't worked?
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