topic Re: Wildcard in QlikView

Wildcard

GregRyder — Wed, 30 Mar 2022 07:20:24 GMT

Here is my formula

Sum(if((TCODE='PU' and [Supplier Code]='S*') ,AMOUNT))

I am trying to get the sum AMOUNT of all [Supplier Code] beginning with the letter 'S' and the * symbol doesn't work

hic — Wed, 30 Mar 2022 07:34:42 GMT

Sum({<TCODE={'PU'},[Supplier Code]={"S*"}>} AMOUNT)

marcus_sommer — Wed, 30 Mar 2022 07:34:49 GMT

Try it in this way:

Sum({< TCODE = {'PU'}, [Supplier Code] = {"S*"}>} AMOUNT))

- Marcus

GregRyder — Wed, 30 Mar 2022 07:53:09 GMT

Thanks that worked perfectly