Qlikview not equal to field value in sheet trigger

[Anonymous]

Hi Team

I have a field compcode it has certain values like AB01, AB02, CD11, CD22,DE34,FG67,RF38,etc. I want to put a sheet trigger onActivateSheet. When user some to this sheet, the value should be,apart from CD11 all other values should get selected.

I tried giving below.combinations, but not working

Select in field : compcode

Search string : <> 'CD11'    ;    Not 'CD11'    ;   -= 'CD11'

Please help.

Thanks !!!

[ogautier62 · Accepted solution]

Hi

you'll have to use two triggers :

first one :

select in field compcode CD11

second :

select excluded values in field compcode

regards

[qlikviewwizard]

Hi,

Create a Flag in the script.

Data:

LOAD *,If(Compcode='CD11',1,0) as Flag INLINE [

Compcode,Sales

AB01,10

AB02,5

CD11,4

CD22,6

DE34,10

FG67,5

RF38,4

];

Use this Flag = 1 in search string of the trigger. Hope this will help you.

[tresesco]

Use two actions:

Action 1: Select in Field (CD11)

Action2: Select Excluded

[tresesco]

Or,

direct search string :    (not like CD11)