topic Re: Qlikview not equal to field value in sheet trigger in QlikView

Qlikview not equal to field value in sheet trigger

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

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

Re: Qlikview not equal to field value in sheet trigger

ogautier62 — Tue, 24 Jul 2018 07:51:03 GMT

you'll have to use two triggers :

first one :

select in field compcode CD11

second :

select excluded values in field compcode

regards

Re: Qlikview not equal to field value in sheet trigger

qlikviewwizard — Tue, 24 Jul 2018 07:51:33 GMT

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.

Re: Qlikview not equal to field value in sheet trigger

tresB — Tue, 24 Jul 2018 07:55:08 GMT

Use two actions:

Action 1: Select in Field (CD11)

Action2: Select Excluded

Re: Qlikview not equal to field value in sheet trigger

tresB — Tue, 24 Jul 2018 08:33:54 GMT

Or,

direct search string : (not like CD11)