topic Re: listbox Filter in QlikView

listbox Filter

Wed, 14 Jan 2015 07:58:56 GMT

Hi,

in my list box i have data like

Cloumnxyz
ABAB-CRDA-SA
AMERICA
ABSD-CRAD-IND
INDIA

by this way i have numer of rows, But i want only alternate rows data in the list box.

can it is possible, if possible plz give the solution

Re: listbox Filter

morganaaron — Wed, 14 Jan 2015 08:28:38 GMT

I'm gonna take a stab in the dark and assume what you're saying is you only want the rows that have genuine country names?

What format are the other values taking? You could exclude them in a if statement to find a certain character like the '-' you've got presented in them, you could consider splitting the values out into two fields...

You may have to clarify/expand a bit more on what you want first!

Re: listbox Filter

arulsettu — Wed, 14 Jan 2015 08:32:40 GMT

hi try this

if(match(Columnxyz,AMERICA,INDIA),Columnxyz)

Re: listbox Filter

tresB — Wed, 14 Jan 2015 08:36:04 GMT

If you want this filter at the script level, could try like:

Load

Columnxyz

From <> where Mod(RecNo(),2);

Update: Similarly for front-end, listbox expression:

=Aggr(If(Mod(RowNo(),2),Columnxyz),Columnxyz)