Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

selecting names in listbox where frequency <>1

Hi,

          i want to select those name in list box whose Frequency <> 1.

          please see the attached sample QVW file for referance.

Thanks

Raul

5 Replies
swuehl
MVP
MVP

Create a button with a select in field action,

Physician

as field

an as search string

='=count(Physician)>1'

edit:

You can also just start typing an advanced search expression in the list box:

=count(Physician)>1

without using an additional button.

Not applicable
Author

I tried but not working....could you please refer  attached qvw n help me on this?

swuehl
MVP
MVP

See attached.

nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Try this in script,

if( ( Count(Physician) =1 ),Null(),Physician)

Or Else

Try this in Dim

If(GetSelectedCount(Physician)<> 1,Physician,0)

Regards,

Nirav Bhimani

Not applicable
Author

Thanks...it helps..!!