# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor II

## If Function - New to Qlik

I am trying to choose a field to select 4 out of 6 items (exclude (0-30), exclude (31-60), include (61-120), include (121-180), include (181-360), include (Over 360)). Then the ones selected to add each amount from the amount field.

Aging = 0-30, 31-60, 61-120, 121-180, over 360

SumIf (A2:A:1500, ">0-30", B2:B1500). I have no idea how to do a sumif in Qlik.

Any help will be appreciated.

Labels (1)
• ### Qlik Sense

2 Solutions

Accepted Solutions
Specialist III

Assuming you have an aging field with values like '0-30'...

=Sum(If(Match(aging,'61-120','121-180','181-360','Over 360') > 0,amount,0))

Master II

One more way is as below:

=Sum({<Aging -={'0-30', '31-60'}>} Amount)

Note: please make a note there is a '-' (hypen) before the equal sign.

4 Replies
Specialist III

Assuming you have an aging field with values like '0-30'...

=Sum(If(Match(aging,'61-120','121-180','181-360','Over 360') > 0,amount,0))

Master II

One more way is as below:

=Sum({<Aging -={'0-30', '31-60'}>} Amount)

Note: please make a note there is a '-' (hypen) before the equal sign.

Contributor II
Author

That worked!! I took out the >0 as there could be negative numbers. Much appreciated!

Contributor II
Author

Trdandamundi, Thank you as well. Learning other solutions is great to gain some knowledge:) Much appreciated!

Tags
Community Browser