Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Specialist III
Specialist III

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.

jagan
Partner - Champion III
Partner - Champion III

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.