Qlik Community

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 
Search instead for 
Did you mean: 
clucky
Contributor II
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)
2 Solutions

Accepted Solutions
jwjackso
Specialist III
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))

View solution in original post

trdandamudi
Master II
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.

View solution in original post

4 Replies
jwjackso
Specialist III
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))

trdandamudi
Master II
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.

clucky
Contributor II
Contributor II
Author

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

clucky
Contributor II
Contributor II
Author

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