Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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
Partner

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