topic Re: Filter in a List box in QlikView

Filter in a List box

Fri, 16 May 2014 14:27:17 GMT

Hi,

I am busy with Comparative analysis and I created 2 groups which consists out of Resort Names. These Resorts are both Local and International resorts. I only want the user to be able to see the Local resorts in each List box. There is a Local/International indicator on my Resort table which indicates if a Resort is Local or International. Where and how would I use this indicator to filter out only the Local resorts to show in the 2 List boxes?

Re: Filter in a List box

Anonymous — Fri, 16 May 2014 14:35:23 GMT

The easiest and most natural way is to create an additional list box with "Local/International" field. Select 'Local' - and your Resort list will show only local.

Another approach is to create calculated list boxes separately for local and international Resorts.

Re: Filter in a List box

Fri, 16 May 2014 14:45:11 GMT

Yes, I've tried the first option, but it doesn't work. I guess it is because I am busy with Comparative analysis and I had to create the groups with an alternate state.

Please tell me more about the calculated list boxes?

Thanks

Re: Filter in a List box

Anonymous — Fri, 16 May 2014 14:55:04 GMT

If a simple solution doesn't work - what can you expect from a more complex? If you use alternate states, make sure that you new "Local/International" list box is in the same state as the "Resorts" list box.

Calculated list box, since you've asked... For the list of Local Resorts, it will be using expression

aggr(only({<[Local/International]={Local}> } Resort), Resort)

Similar for International.

(Assuming I guessed right the field name and values...)

Re: Filter in a List box

Mon, 19 May 2014 06:37:56 GMT

Thanks Michael,

I made sure the Local/International List box is in the same state as the Resort List box and now it is working.

Thanks for your help.