Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear community
I have a problem:
I have a QVD and excel with the following data:
I need to find the Excel ID in the QVD group.
A group can have several IDs but I only need the ID that is in the excel and the total sum of all the IDs in the group.
Thanks for your help
Cheers
RM
I think the result for ID 1 is 5390, not 5393
For Qlik Sense (I used QlikView) adapt the loads
Can you elaborate the Question ?
Is this what you are expecting?
I think the result for ID 1 is 5390, not 5393
For Qlik Sense (I used QlikView) adapt the loads
Hello @maxgro
Thank you very much for your help.
You have helped me a lot.
How can I add the "Group" field? in the final table.
Thx.
RM
add an aggregation function (only, maxstring, minstring, ...)
// load the final table
T_Result:
LOAD
ApplyMap('MapGroupToID', Group_ID) as ID,
SUM(Value) AS Value,
ONLY(Group_ID) AS Group_ID
FROM File_QVD.qvd (qvd)
WHERE EXISTS (Group_ID)
GROUP BY ApplyMap('MapGroupToID', Group_ID)
;