topic Use of Wildmatch in expression in QlikView

Use of Wildmatch in expression

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

Hello

We have a number of portfolios and I would like to limit the portfolios to those starting with code '125'

I think wildmatch is the way to go but am not 100% sure.

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},

account = {1101,1201,1301,1401}, portfolio = {wildmatch(portfolio,'125*')>0)}

>} GBP)

I have tried a few different variations of the code above but am struggling.

Could someone please suggest the way to do this.

Many thanks

Paul

Kushal_Chawda — Wed, 13 Apr 2016 16:24:59 GMT

sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"},

account = {1101,1201,1301,1401}, portfolio = {'125*'}

>} GBP)

paul_ripley — Wed, 13 Apr 2016 16:30:57 GMT

Thanks, I guess I was over complicating it!