Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to select based on expression

Hi all,

I want to select those items in a list box that have frequency more than 2. Any way to select it using expression/advance search? I can't get the advance search to work. (i.e. count(ID) > 1)

2 Replies
Employee
Employee

Re: How to select based on expression

if you as search string use =Count(ID)>1 then it should work. Including the equal sign.

Image1.png

HIC

MVP
MVP

Re: How to select based on expression

=count(YourField)>2

Community Browser