Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
Creator III
Creator III

Use of Wildmatch in expression

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

1 Solution

Accepted Solutions
Kushal_Chawda

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

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

>}  GBP)

View solution in original post

2 Replies
Kushal_Chawda

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

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

>}  GBP)

paul_ripley
Creator III
Creator III
Author

Thanks, I guess I was over complicating it!