Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sharmasapna
New Contributor III

Qlikview not equal to field value in sheet trigger

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 !!!

1 Solution

Accepted Solutions
ogautier62
Valued Contributor II

Re: Qlikview not equal to field value in sheet trigger

Hi

you'll have to use two triggers :

first one :

select in field compcode CD11

second :

select excluded values in field compcode

regards

View solution in original post

4 Replies
ogautier62
Valued Contributor II

Re: Qlikview not equal to field value in sheet trigger

Hi

you'll have to use two triggers :

first one :

select in field compcode CD11

second :

select excluded values in field compcode

regards

View solution in original post

qlikviewwizard
Honored Contributor II

Re: Qlikview not equal to field value in sheet trigger

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.

MVP
MVP

Re: Qlikview not equal to field value in sheet trigger

Use two actions:

Action 1: Select in Field (CD11)

Action2: Select Excluded

MVP
MVP

Re: Qlikview not equal to field value in sheet trigger

Or,

direct search string :    (not like CD11)