How many Duplicate method

[saumyashah90]

I need to find which methods are complete duplicates and which all are subset.

Attached excel.

Under sheet1,

we can see some methods and their parameters.

For some methods parameters are same that means two methods are duplicates and some methods have parameters included in to some other methods parameters which means they are the subset.

[Gysbert_Wassenaar]

See attached qvw for finding the duplicates.

[saumyashah90]

Hi gysbert,

thanks for responding.

I need a extra column saying its duplicate or not.

like

with addition to this http://community.qlik.com/thread/140325 i need one more column which shows duplicates,subset and no match