If Statement with multiple conditions

[robertsb41]

I am trying to create a calculated field based on multiple columns Contract ID, Bid Rank, and Amount.  If Bid Rank = 2 then I want Amount displayed for each row of the Contract ID.

This displays the amount but only for the row where bid rank =2, If([Bid Rank]=2, Amount).

So what I am getting is:

Contract ID	Bid Rank	Amount	Low
27	1	250	-
27	2	350	350
27	3	450	-
62	1	10	-
62	2	20	20
62	3	30	-
62	4	40	-
73	1	100	-
73	2	450	450

What I want is:

Contract ID	Bid Rank	Amount	Low
27	1	250	350
27	2	350	350
27	3	450	350
62	1	10	20
62	2	20	20
62	3	30	20
62	4	40	20
73	1	100	450
73	2	450	450

[sunny_talwar · Accepted solution]

calculated field? Meaning calculated dimension? Try this for calculated dimension

Aggr(NODISTINCT
    Sum({<[Bid Rank] = {2}>} Amount)
, [Contract ID])

[robertsb41]

That did it.  Thank you!  I guess you cannot do this in data manager?  Sorry, I've only been using Qlik for less than a month and not real savvy yet.  Thanks again.

[sunny_talwar]

Data manager is something which is available in Qlik Sense and I mostly have been working on QlikView. May be someone with more knowledge about Data Manager/Qlik Sense can answer this for you.