Solved: Sum a range of Accounts - Qlik Community

nedcliqs · ‎2017-10-25

Hi Community,

Please help with a simple formula to Sum a range of Account numbers as follows:

1. Sum Amount for the Accounts 5722 to 5728 ( I want to state a range NOT to list them all)

2. Sum Amount for the range of Accounts 2300 to 2480

3. Then Subtract (2.) from (1.)

Below is just a sample , the Accounts are way too many than this hence the reason why i cant use a formula such as

WHERE Acc IN (5722, 5722.........)

Anonymous · ‎2017-10-25

If account is numeric you could try

sum({<Account={'>=2300<=2480'}>}Amount) - sum({<Account={'>=5722<=5728'}>}Amount)

Anonymous · ‎2017-10-25

If account is numeric you could try

sum({<Account={'>=2300<=2480'}>}Amount) - sum({<Account={'>=5722<=5728'}>}Amount)

Miguel_Angel_Baeyens · ‎2017-10-25

That syntax with double quotes as long as it is a search, single quotes work, but it's a known bug.

nedcliqs · ‎2017-10-25

Thanks @Wallo Atkinson, this worked correctly on my sample data.

I will apply then apply the formula on the model and see how it goes.

Once again, thank you

Anonymous · ‎2017-10-25

Good luck. Hope it helps.

nedcliqs · ‎2017-10-26

Hi atkinsow‌, i applied the formula on my model. It worked like charm!

Thank you very much for helping here!

Sum a range of Accounts