Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Specialist II
Specialist II

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
Specialist II
Specialist II

Hi

you'll have to use two triggers :

first one :

select in field compcode CD11

second :

select excluded values in field compcode

regards

qlikviewwizard
Master II
Master II

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

Use two actions:

Action 1: Select in Field (CD11)

Action2: Select Excluded

tresesco
MVP
MVP

Or,

direct search string :    (not like CD11)