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

The result will be:  20* + 59*  and not  >=20* <=59*

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

That's nice but I'd like to avoid the If statement and use Set analysis instead.

AbhijitBansode
Specialist
Specialist

may be something like below:

sum ( {< Accounts= {"20*"} + {"30*"} + {"40*"} + {"50*"} > } Actuals)

thierrytt1102
Partner - Creator II
Partner - Creator II
Author

It's gonna work but my exemple was quite simple compared to what I have to do 🙂  I'll still maintain my request open.
thanks for your time

MayilVahanan

HI

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

This is not works??

Otherwise try this also

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



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

ok

is what you are looking for

sum( {$<Account = P({1<Account={">=20*<=50*"}>})>} Acutals)