topic Re: Filter Selection in QlikView

Filter Selection

Wed, 29 Jan 2014 00:06:32 GMT

Hello,

I have a set of reason code used as a filter.

Reason_Code

'Blank'

'01'

'02'

'03'

'04'

'05'

I have to include this 'Blank' code along with any other reason codes every time when I change the selection in order to make a percentage calculation meaningful. Are there anyways to fix that 'Blank' selection? Or, do I have to create a calculated field to do this?

Your help is much appreciated. Thanks.

Re: Filter Selection

senpradip007 — Wed, 29 Jan 2014 04:11:11 GMT

Hi Lin.

Do you mean that when you select 03 or 04 it is autometically select 'Blank' also?

If it is so try this

=Sum({<Reason_Code = Reason_Code + ({'Blank'}) >} Value)

regards.

Re: Filter Selection

sujeetsingh — Wed, 29 Jan 2014 04:42:12 GMT

Lin i do not get it .

Can you post a sample

Re: Filter Selection

Wed, 29 Jan 2014 06:04:32 GMT

Two way to solve it out

1- simple use suppress null values in dimensions.

2- suppress on scrip level use this query

use where condition

where Reason_Code <> ' ' or Reason_Code <> 'Blank' ;

Re: Filter Selection

Wed, 29 Jan 2014 07:17:49 GMT

You can make it possible using trigger on the field.

GO to Setttings-> Document Properties-> Triggers-> Field Event Triggers

Add "OnSelect" trigger on the field Reason_Code, then

Then "Select in Field"

Field as Reason_Code

SearchString as

='('&concat(Reason_Code,'|')& '|' &'Blank' &')'

Thanks,

Angad