# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

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

😕

Partner
Author

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))

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)