Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Summarizing a range of accounts

I have a table that looks something like this:

Account     Amount

1511          100

3010          230

4020          110

8990          130

4010          150

If I want to summarize the amount on accounts 3000 to 3999 and 4000 to 4029, how would you write that in an expression?

Best regards

Thor

3 Replies
Not applicable

Summarizing a range of accounts

Hi Thor,

try these expressions:

1. sum(if (Account >3000 and Account < 3999, Amount))

2. sum(if (Account >4000 and Account < 4029, Amount))

May be you need ">=".

RR

mdmukramali
Valued Contributor III

Re: Summarizing a range of accounts

Dear,

Thor.

we can do it by using set Analysis

1) summarize the amount on accounts 3000 to 3999

                                =sum({1<Account= {">=3000<=3999"}>}Amount)

2) summarize the amount on accounts 4000 to 4029

                            =sum({1<Account= {">=4000<=4029"}>}Amount)

Thanks,

Mukram.

MVP & Luminary
MVP & Luminary

Summarizing a range of accounts

Hi,

Try this expressions

For 3000 and 3999

=Sum({<Account= {'>=3000<=3999'}>} Amount)

For 4000 and 4029

=Sum({<Account= {'>=4000<=4029'}>} Amount)

Hope this helps you.

Regards,

Jagan.