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

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

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

thierrytt
Partner
Partner
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
er_mohit
Master II
Master II

ok

is what you are looking for

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