topic Re: Remove duplication and sum value in QlikView

Remove duplication and sum value

engishfaque — Thu, 22 Jan 2015 07:11:24 GMT

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.

Kind regards,

Ishfaque Ahmed

kushalthakral — Thu, 22 Jan 2015 08:08:45 GMT

Dear Ahmed

pleas try wildmatch function for the same requirement.

Regards

Kushal Thakral

Thu, 22 Jan 2015 09:45:12 GMT

Try using this

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

kavita25 — Thu, 22 Jan 2015 10:09:29 GMT

Hi,

Check the given application.

kavita25 — Thu, 22 Jan 2015 11:04:37 GMT

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.