Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
thierrytt
Partner
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
MayilVahanan

Hi

Try like this

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

Hope that helps

Thanks & Regards,
Mayil Vahanan R
er_mohit
Master II
Master II

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

thierrytt
Partner
Partner
Author

Thx for your response.

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

😕

thierrytt
Partner
Partner
Author

Thx for your response.

I also tried this alternative but it returned 0.

😕

thierrytt
Partner
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

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
Not applicable

try this,

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

er_mohit
Master II
Master II

try this

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