Exact match in tables

[emrekaya]

Hi all, 

I want to know how to get an exact match in a table in qliksense. If you help me I would be appreciated. Is there any function that I can use to find the exact match in a table like below? When I filter first 7 characters, it filters everything including that 7 characters but this is not what i want. I want to find the exact match. 

Thank you in advance.

[pradosh_thakur]

There is a match function. have a look.

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Co...

[emrekaya]

I had already checked the match function in help but I couldn't figure it out how to appy that function into my app. Thanks.

[pradosh_thakur]

You need to tell more about the data and the out put

[emrekaya]

Data is exactly the same with the picture that I added. I want to sum the values of the grey elements, only the grey elements. I can't use max function or sum, because if I use, it gives me the wrong answer.

[pradosh_thakur]

try

sum(if(len(trim([WBS ELEEMENT]))=7, [Total Spending],0))

Please correct the field names

[emrekaya]

It didn't work. The reason is probably because the last element has 9 digits. 

[pradosh_thakur]

You have to figure out some logic which will fit your case.