Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
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.

Tags (4)
15 Replies
Highlighted

Re: Range with * in set analysis

Hi

Try like this

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

Hope that helps

Highlighted
Honored Contributor II

Re: Range with * in set analysis

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

Highlighted
Partner
Partner

Re: Range with * in set analysis

Thx for your response.

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

😕

Highlighted
Partner
Partner

Re: Range with * in set analysis

Thx for your response.

I also tried this alternative but it returned 0.

😕

Highlighted
Partner
Partner

Re: Range with * in set analysis

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

Highlighted
Contributor

Re: Range with * in set analysis

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)

Highlighted

Re: Range with * in set analysis

HI

Try like this

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

Highlighted
Not applicable

Re: Range with * in set analysis

try this,

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

Highlighted
Honored Contributor II

Re: Range with * in set analysis

try this

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