Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
robertsb41
Contributor III
Contributor III

Calc Field or Expression or ...

I'm working with 4 fields, ID, Bidder, Rank, Amount.  I want to create a field called Low, ideally in data manager but not critical.

For each ID, I want to display in the low field if Bidder = Rank 1, then display Amount for Bidder =Rank2.  But if Bidder is Rank >=2, then display Amount for Bidder=Rank1.   So my data would look like this:

IDBidderRankAmountLow
10A11020
10B22010
10C33010
10D44010
20D1100200
20B2200100
20A3300100
20C4400100

 

Thank you!

Labels (3)
1 Solution

Accepted Solutions
Kushal_Chawda

add below expression

=if(Rank>=2, sum(total <ID>{<Rank={1}>}Amount),
sum(total <ID>{<Rank={2}>}Amount))

View solution in original post

1 Reply
Kushal_Chawda

add below expression

=if(Rank>=2, sum(total <ID>{<Rank={1}>}Amount),
sum(total <ID>{<Rank={2}>}Amount))