Filtering values in Table but its not reflect

[harshalshah]

Hi Qlik Users,

Kindly help me on Qlik Table (want to filter values whose sum(PNs_found ) <10 only those PNs should be reflect but here I'm getting all values (false condition (display as "-"))

IF(Sum(PNs_found) < 10, Sum(PNs_found))

If anyone having solutions do let me know..thanks

[BrunPierre]

Hi, Since there are other measures, you must also apply conditions to them. And perhaps, either uncheck 'include zero values' under the dimension or under Add-Ons-> Data handling.

Here's the set analysis expression.

=Sum({$<[Part Number]={"=Sum(PNs_found) < 10"}>} PNs_found)

[udit_k]

uncheck Include Zero Value in Data Handling

[harshalshah]

Hi Brun,

I tried to applied logic but its not working filter also not applied (earlier showing <10 as "-" but now its even nothing works )all values populated with Set statement.

=Sum({$<[Part Number]={"=Sum(PNs_found) < 10"}>} PNs_found)

I want result only displayed with Capture2 "Filter" PNs_found <10 count only rest want displayed in filter.

[harshalshah]

even after uncheck Data handling its displayed all the rows.

[harshalshah]

issue resolved post all the measure values filter in table with the same condition.