topic Re: Range with * in set analysis in QlikView

Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 10:30:43 GMT

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.

Re: Range with * in set analysis

MayilVahanan — Fri, 09 Aug 2013 10:47:52 GMT

Try like this

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

Hope that helps

Re: Range with * in set analysis

er_mohit — Fri, 09 Aug 2013 11:00:04 GMT

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

Re: Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 11:09:13 GMT

Thx for your response.

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

😕

Re: Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 11:09:39 GMT

Thx for your response.

I also tried this alternative but it returned 0.

😕

Re: Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 11:12:00 GMT

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

Re: Range with * in set analysis

anandathome — Fri, 09 Aug 2013 11:19:09 GMT

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)

Re: Range with * in set analysis

MayilVahanan — Fri, 09 Aug 2013 11:23:48 GMT

Try like this

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

Re: Range with * in set analysis

Fri, 09 Aug 2013 11:26:28 GMT

try this,

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

Re: Range with * in set analysis

er_mohit — Fri, 09 Aug 2013 11:26:48 GMT

try this

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

Re: Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 11:51:00 GMT

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

Re: Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 11:51:52 GMT

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

Re: Range with * in set analysis

AbhijitBansode — Fri, 09 Aug 2013 12:03:06 GMT

may be something like below:

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

Re: Range with * in set analysis

thierrytt1102 — Fri, 09 Aug 2013 12:13:42 GMT

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

Re: Range with * in set analysis

MayilVahanan — Fri, 09 Aug 2013 12:17:29 GMT

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

This is not works??

Otherwise try this also

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

Re: Range with * in set analysis

er_mohit — Fri, 09 Aug 2013 12:28:15 GMT

is what you are looking for

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