Need to filter excel data in load editor

[arvsuri007]

Hi all,

I am trying to filter data with unique values from my data set. I have made an expression just to filter out data in load editor.

If(datafield= peek(datafield),1,0)

I want to use an expression to filter data with value '1' in load editor. Please help.

Regards,

Arvind

[wade12]

perhaps you might experiment with where exists and/or where not exists.

[arvsuri007]

I tried but "where" condition is not working. 😞

[wade12]

it should be "where exists"

open the example & results section in this link:

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