# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## Range with * in set analysis

Dear,

Simple question, I'd like to sum Actuals from accounts 20* to 59*.

I was not able to find a way to handle this in set analysis,

Can someone help?

Thx a lot.

15 Replies
MVP

Hi

Try like this

=Sum({<accounts = {">=20*<=59*"}>}Actuals)

Hope that helps

Thanks & Regards,
Mayil Vahanan R
Master II

sum(\${<accounts={'>=20* <= 59*'}>}Actuals)

Partner
Author

Thx for your response.

Actually that's what I tried but it returned 0.

😕

Partner
Author

Thx for your response.

I also tried this alternative but it returned 0.

😕

Partner
Author

Guys,

In other words, I'd like to have the similar result BUT in set analysis:

sum(if(wildmatch(Account,'20*','50*'),Actuals))

Thx for your help

Creator

Hi Their,

Do you know the length of account number.

If yes then create the lowest number(account number) and

highest number(account number)

and use them in set analysis.

Sum({<accounts = {">=200000000<=59999999999"}>}Actuals)

MVP

HI

Try like this

=Sum({<Account = {"20*","50*"}>}Acutals)

Thanks & Regards,
Mayil Vahanan R
Not applicable

try this,

sum(if(wildmatch(Accounts,'20*','50*'),Actuals))

Master II

try this

sum(\${<accounts={'20*',' 59*'}>}Actuals)