Sum if dimension included in a specific range of values

[orlando162]

Dear all,

I'm trying to avoid similar extended formulas like --> Sum({<[Doc] = {'Invoice'}, Account = {'3001'}>} [Amount]) + Sum({<[Doc] = {'Invoice'}, Account = {'3002'}>} [Amount]) + Sum({<[Doc] = {'Invoice'}, Account = {'3003'}>} [Amount]) + Sum({<[Doc] = {'Invoice'}, Account = {'3004'}>} [Amount]) + Sum({<[Doc] = {'Invoice'}, Account = {'3005'}>} [Amount])

I would like to create a formula to sum all the [Amount] labeled as [Doc] = 'Invoice' if the Account No. is included in the range of 3001-3005.

Thank you in advance,
Andrea

[eddie_wagt · Accepted solution]

Hello @orlando162 ,

You could do the same within one expression:

Sum({<[Doc] = {'Invoice'}, Account = {">=3001<=3005"}>} [Amount])

Kind regards

Eddie

If this answers your question or solves your issue, be sure to mark the answer as correct by clicking 'Accept as Solution'. This will mark the post as solved and other Qlikkies will gravitate towards this post as it as a possible solution for their issue. Multiple responses can be accepted as a solution so make sure to select all that apply.

[vinieme12]

refer below for more

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907