Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

chrisgoudy
New Contributor II

Drop the selection PharmacyName that appears under the field PharmacyName

I know it's possible to remove PharmacyName from the Listbox alone, but i need to use this field other places.
So it would work best if I dropped it in the script I think.

1 Solution

Accepted Solutions
sivarajs
Valued Contributor II

Drop the selection PharmacyName that appears under the field PharmacyName

try this in script

load *

from filepath

where substringcount(PharmacyName,'PharmacyName')=0;

6 Replies
Not applicable

Re: Drop the selection PharmacyName that appears under the field PharmacyName

select 'expression' in the 'Field' dropdown list of the list box object and type in:

if(PharmacyName<>'PharmacyName',PharmacyName)

chrisgoudy
New Contributor II

Drop the selection PharmacyName that appears under the field PharmacyName

will this just drop it from the listbox?

If I use the field PharmacyName in a chart will PharmacyName appear as a selection?,

Not applicable

Drop the selection PharmacyName that appears under the field PharmacyName

yes, only from the listbox

chrisgoudy
New Contributor II

Drop the selection PharmacyName that appears under the field PharmacyName

I want to drop it from everything. How can I do that?

sivarajs
Valued Contributor II

Drop the selection PharmacyName that appears under the field PharmacyName

try this in script

load *

from filepath

where substringcount(PharmacyName,'PharmacyName')=0;

chrisgoudy
New Contributor II

Drop the selection PharmacyName that appears under the field PharmacyName

Perfect, thank you

Community Browser