topic Select on field action for value start with Code except one value in QlikView

Select on field action for value start with Code except one value

ghassanaldalati — Sat, 16 Nov 2024 18:12:29 GMT

Dear All :

I have WHId table with many cods ( x21 - x10 - xx3 - xx1 - d20 - e30 .......)

I am trying to make Select in field action a way to choose all WHId start with (x) except (xx1)==>[ x21-x10-xx3]

i trying this code

= '(' & Concat({< WHId -= {'XX1'}>}WHId,'|') &'"X*"'')'

olso i try

( "X*" | -'XX1')

please help me...

Re: Select on field action for value start with Code except one value

Kushal_Chawda — Thu, 20 Aug 2020 13:47:24 GMT

you can use below search string. Where XX1 is the string you want to exclude. you can have multiple exclusion as well with comma separated values like {'XX1','XX2'}

='('&Concat({<Code={"X*"}-{'XX1'}>} chr(34)&Code&chr(34),'|')&')'

Re: Select on field action for value start with Code except one value

Kushal_Chawda — Thu, 20 Aug 2020 13:50:48 GMT

or simply below search string in trigger

(X*^XX1)

Re: Select on field action for value start with Code except one value

ghassanaldalati — Thu, 20 Aug 2020 14:39:31 GMT

='('&Concat({<WHId={"X*"}-{'XX1'}>} chr(34)&WHId&chr(34),'|')&')'.......((GREAT.....thankyou))

but what chr(34) mean...??

Re: Select on field action for value start with Code except one value

Kushal_Chawda — Thu, 20 Aug 2020 15:14:16 GMT

chr(34) holds double quote(") character, basically in the end it generated string like ("X1"|"X2"....)