Qlik Community

Qlik Sense App Development

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

arvsuri007
New Contributor

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

Re: Need to filter excel data in load editor

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

arvsuri007
New Contributor

Re: Need to filter excel data in load editor

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

Partner
Partner

Re: Need to filter excel data in load editor

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