Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thierrytt1102
Partner - Creator II
Partner - Creator II

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
MayilVahanan

Hi

Try like this

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

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
er_mohit
Master II
Master II

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

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

Thx for your response.

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

😕

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

Thx for your response.

I also tried this alternative but it returned 0.

😕

thierrytt1102
Partner - Creator II
Partner - Creator II
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

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

MayilVahanan

HI

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable

try this,

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

er_mohit
Master II
Master II

try this

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