topic Filter in QlikView

Filter

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi i have a field called cast

Iam taking this field as a filter and i want to display only two values in this how do i do this

currently this is how it looks

I want to show only Sal and Bor in this filter

Thanks

Re: Filter

Or — Tue, 06 Jun 2017 09:00:26 GMT

Depending on what you want to achieve, you can do this several ways:

1) Filter the data in the original script.

2) Create a second field, Cast_Filter, with the syntax if(Cast = 'Sal' or Cast='Bor',Cast) as Cast_Filter and use that. This is usually the recommended approach if you can't filter the data in the original script.

3) Use a similar expression in your list box (Set it to <Expression> first).

Re: Filter

Anil_Babu_Samineni — Tue, 06 Jun 2017 09:00:40 GMT

May be use, Expression for Cast

=If(Match(Cast,'Sal','Bor'), Cast)