Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
arvsuri007
Contributor II
Contributor II

Need to filter excel data in load editor

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

 

3 Replies
wade12
Partner
Partner

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

arvsuri007
Contributor II
Contributor II
Author

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

wade12
Partner
Partner

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...