Remove duplication and sum value

[engishfaque]

Dear All,

I'm facing an issue for removing duplication and adding the values of these duplicate records.

I'm attaching my qvw, qvd and screenshot for better understanding.

I followed this thread, It is useful but not working in my scenario.

Merge two values

Kind regards,

Ishfaque Ahmed

[kushalthakral]

Dear Ahmed

pleas try wildmatch function for the same requirement.

Regards

Kushal Thakral

[#3 · Accepted solution]

Try using this

if(wildmatch(SKU,  peek(fieldgroup)& '*') and len(peek(SKU))>0, peek(fieldgroup), SKU) as fieldgroup

[kavita25]

Hi,

Check the given application.

[kavita25]

FYI,

Its not the script error.

i think, without reloading the qvw, you checked that the written script is working or not.

Without editing the script, just reload the qvw. you will get the output.